Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Connect one-on-one with {0} who will answer your question

Related Microsoft Office Questions
I have multiple sheets in my spreadsheet that represent a
I have multiple sheets in my spreadsheet that represent a box number, 300 to 400. Each box is filled with last name in column A and first name in column B and box number in D. What is the best way to … read more
Bing
Bing
Freelance IT Consultant
639 satisfied customers
I have an excel question. I have a database download
I have an excel question.I have a database download worksheet with data sorted in columns. The first column is the all model numbers with multiple part descriptions for each model (i.e. 30-40 parts wi… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
I need some help with figuring out how a pivot table can
Hello, I need some help with figuring out how a pivot table can help me sort terms for a glossary and compare across what will probably be 10 different glossaries of terms to see where the overlap is.… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
I am looking for a formula (index match match I assume) that
I am looking for a formula (index match match I assume) that enters the sum of column H on another worksheet (let's call it Sheet2). For instance I want to match cell A3 (last name, first name) on She… read more
Bing
Bing
Freelance IT Consultant
639 satisfied customers
We are working with sales spreadsheets, we need to combine
Hi, We are working with sales spreadsheets, we need to combine them; they have one product number in common as a unique identifier in one column in each spreadsheet, however, the rows are not the same… read more
Bruce Wilner
Bruce Wilner
Master of Engineering
33 satisfied customers
I need help importing (or copying) a spreadsheet of a data
I need help importing (or copying) a spreadsheet of a data into another spreadsheet in a way that my VLOOKUP formulae will work. I can provide the data file, the destination file, and also another fil… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
I am trying to match part numbers from one spreadsheet with
I am trying to match part numbers from one spreadsheet with 80000 lines to another with 1000 lines and then extract data from the row of the 80000 lines and insert it on the row next to the matching p… read more
Richard
Richard
IT Manager
IT Manager, Consultant
16,235 satisfied customers
I HAVE A SPREADSHEET, i NEED TO KNOW IF A NUMBER IN COLUMN A
i HAVE A SPREADSHEET , i NEED TO KNOW IF A NUMBER IN COLUMN A EXIST IN A DIFFERENT COLUMN, AND BE ABLE TO FLAG IT? ANY HELP WOULD BE APPRECIATED.… read more
Jason Jones
Jason Jones
AAS Information Technology
12,406 satisfied customers
I have two spreadsheets that have some matching items in
Hi, I have two spreadsheets that have some matching items in them.....how can I compare these two without going line item by line item? Is it VLOOKUP, MATCH or INDEX? Non of my formulas are working...… read more
Richard
Richard
IT Manager
IT Manager, Consultant
16,235 satisfied customers
Looking importing the data from a master site list
looking for help importing the data from a master site list from one worksheet into the sales order template worksheet, and then generate a new worksheet for each row of information that is imported i… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
ExcelI have a sample spread sheet which has three vendors
Excel I have a sample spread sheet which has three vendors with 3 different prices for a part. I would like a formula that will pick out the vendor with the lowest cost and put the corresponding infor… read more
Zabo04
Zabo04
Master\u0027s Student
Master's Degree
173 satisfied customers
I have a very large spreadsheet (50,000+lines) and I need to
I have a very large spreadsheet (50,000+lines) and I need to pull the minimum value for a series of cells as follows. The layout of the spreadsheet lists a finished good on line 1 followed by the comp… read more
Richard
Richard
IT Manager
IT Manager, Consultant
16,235 satisfied customers
I have a long list of cities and I need to add a column next
I have a long list of cities and I need to add a column next to it with a corresponding numeric code. For example, I currently have this: New York Vancouver Hong Kong And I need it to look like this: … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
I have two sheets in one Workbook. One is a live inventory
I have two sheets in one Workbook. One is a live inventory of my cooler doors with over 540 products. The other is a History tab with over 1400 products. I would like to link pricing information betwe… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
I need to create a spreadsheet that will not allow the numbers
I need to create a spreadsheet that will not allow the numbers to move from column A to B if the numbers that are entered are not the same (the numbers can be 123, 321,213 but if I enter 124, if doesn… read more
Marco
Marco
Director IT Consultant
Master's Degree
508 satisfied customers
Hi,I have two Microsoft Excel spreadsheets which I want
Hi, I have two Microsoft Excel spreadsheets which I want to merge into one spreadsheet. They have one column in common, let's call it ID. I only want to merge them in those cases where there is a matc… read more
John D
John D
Bachelor Degree in Engineering
140 satisfied customers
Two related questions. I have about 10,000 lines of data in
Two related questions. I have about 10,000 lines of data in two excel spreadsheet, about 5,000 each. The data in each spreadsheet is 95% idential. I need to compare the two speadsheets and pull out th… read more
John D
John D
Bachelor Degree in Engineering
140 satisfied customers
In an Excel spreadsheet, how can I assign a numerical value
In an Excel spreadsheet, how can I assign a numerical value to a text item. For example: in a spreadsheet with thousands of instances of "product A", "service B", "other item X" etc., where certain to… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
2,382 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

1,048 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,382 satisfied customers

20 years experience providing remote computer support

Kamil Anwar

Kamil Anwar

Office Specialist

342 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

186 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

171 satisfied customers

Certified Expert with over 10 years experience.

Shefin

Shefin

Microsoft Office Specialist

150 satisfied customers

Working as Tech support specialist with a world famous computer manufacturer

Steve Herrod

Steve Herrod

Computer Support Specialist

132 satisfied customers

Trained in Microsoft Office from 2000 through to latest version 2010.

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x