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 670 text files within one folder. Each text file
Hi. I have 670 text files within one folder. Each text file contains a short text string. I have an excel spread sheet that contains 670 rows that give particulars about each of the text files. I woul… read more
JenniferThomasComp
JenniferThomasComp
Computer Engineer
Bachelor's Degree
466 satisfied customers
I need help with conditional formatting. Microsoft excel
i need help with conditional formatting JA: What app are you using? Customer: microsoft excel JA: Have you updated Excel recently? Customer: yes JA: Anything else you want the Microsoft Office Expert … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
841 satisfied customers
I have an excel formula that i need help with. O365
i have an excel formula that i need help with JA: What version of Excel are you using? Customer: O365 JA: Have you updated Excel recently? Customer: yes JA: Anything else you want the Microsoft Office… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
841 satisfied customers
I need a formula for my data in Excel, fairly simple, I
I need a formula for my data in Excel, fairly simple, I think.I have 12 different numbers in the same column and need a formula that asks: If (cell A is less than cell A by 20%, cell B is less than ce… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
841 satisfied customers
I have a column of data 10,000 rows. i need to know the
i have a column of data 10,000 rows long. i need to know the average of rows 1 thru 20, rows 21 thru 40, rows 41 thru 60 and so on. … read more
Divyansh
Divyansh
Bachelor's Degree
1,746 satisfied customers
I have an excel conditional formatting question. I have
I am working between two worksheets in the same workbook. the first worksheet is an infection control log. the second worksheet is a tracking and trending grid. I want to make the second sheet conditionally format a certain color is a row in the first workbook contains two criteria. The key, however, is that the worksheet being formatted won't have either of the criteria in that cell. … read more
Bing
Bing
Freelance IT Consultant
1,394 satisfied customers
I have attached a example excel file Please use this file.
I have attached a example excel file Please use this file. In Excel I want to Filter the data with the advanced filter without using the sort option. I don't want the list turned into a table and I do… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
841 satisfied customers
I have an excel spread sheet which identifies 1,400 loans.
I have an excel spread sheet which identifies 1,400 loans. Column D identifies the loan amounts. My boss wants me to only identify the loans valued at less than one million dollars. He also wants me t… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
1,337 satisfied customers
I am using excel 2016 and have a column of numbers that are
I am using excel 2016 and have a column of numbers that are formatted as general after 4,000 rows I come across a cell that is still formatted as general yet has that little yellow indicator that the … read more
Pete
Pete
Senior Engineer
Bachelor's Degree
3,498 satisfied customers
I am working on/analyzing an Excel file with nearly 1000 data
I am working on/analyzing an Excel file with nearly 1000 data entries. I'm using AutoFilter to see if some of the items happen multiple times. Is there a quick and simple way to find out: 1. How many … read more
Zabo04
Zabo04
Master\u0027s Student
Master's Degree
173 satisfied customers
I am trying to write an excel formula that I can run a
I am trying to write an excel formula that I can run a rolling average of 30 numbers but I have zeros inter mixed with my average and I want it to not only to exclude the zeros in the value but also i… read more
Zabo04
Zabo04
Master\u0027s Student
Master's Degree
173 satisfied customers
Count the number of occurrences in a filtered range.
I want to count the number of occurrences in a filtered range. Specifically how many times does "Jan" show up in the column that is filtered Better yet, I have a date column 99/99/99 and would like to… read more
R. Michael
R. Michael
MIS Analyst
Master's Degree
22 satisfied customers
Im using VLOOKUP to reference a bunch of tables I have on
I'm using VLOOKUP to reference a bunch of tables I have on several sheets. It's looking up a sounding number, and sending back the corresponding volume to that sounding. It works, but I want to improv… read more
flopcat98
flopcat98
Consultant
Bachelor's Degree
214 satisfied customers
I have to add 3 blank rows, based on information in column
I have to add 3 blank rows, based on information in column 1 which is the order number. All order numbers have different number of rows associated with them. Example: 12 12 12 13 13 14 14 14 14 So I h… read more
Michael Hannigan
Michael Hannigan
Bachelor's Program
4,102 satisfied customers
Hi. I am a novice when it comes to excel but i recently have
Hi. I am a novice when it comes to excel but i recently have had to use it frequently and would like some advice on creating a formula for a spreadsheet i am creating. I am a sports coach and i would … read more
Richard
Richard
IT Manager
IT Manager, Consultant
18,198 satisfied customers
I am trying to identify common criteria between 2 cells using
I am trying to identify common criteria between 2 cells using Excel 2007. For instance: I have a series of numbers and possibly letters in 1 cell (manufactures part number). I want to compare to anoth… read more
John D
John D
Bachelor Degree in Engineering
140 satisfied customers
Hi, I am trying to create a consecutively numbered column
Hi, I am trying to create a consecutively numbered column with a suffix where the suffix stays the same and the number before it changes. For example, I need it to look like this: R000501 17 R000502 1… read more
John D
John D
Bachelor Degree in Engineering
140 satisfied customers
I have the following data in an excel spreadsheet: =IF(G70,G7/G8*100,"&quo
I have the following data in an excel spreadsheet: =IF(G70,G7/G8*100,""). I put a score in and understand this formula to be telling me that if Column G7 is less than or greater than zero, divide G7 w… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
841 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,337 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

841 satisfied customers

20 years experience providing remote computer support

Shefin

Shefin

Microsoft Office Specialist

494 satisfied customers

Working as Tech support specialist with a world famous computer manufacturer

Kamil Anwar

Kamil Anwar

Office Specialist

493 satisfied customers

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

James K.

James K.

Consultant

390 satisfied customers

Technical Director of IT Company

flopcat98

flopcat98

Consultant

214 satisfied customers

degree in comp sci. 20+ years install work with networks for small and large companies

Miro

Miro

Computer Support Specialist

211 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< 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