Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Related Microsoft Office Questions
I am stuck on a certain question. Imagine I have 2 sets of
Imagine I have 2 sets of similar data in Microsoft Excel, on 2 different tabs. How might y o u f i n d t h e f o l l o w i n g : ( F​ e e l i n g i n d u s t r i o u s ? I n c l u d e a t a b l e w i t h y o u r w o r k . )​ a) IDsfoundintab1butnotintab2. b) All data from tab 1 that matches IDs from tab 2. c) The total number of IDs that don't match between the 2 tabs. Can you do it in a single formula? … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
751 satisfied customers
I am trying to return a value based on criteria between two
Hi I am trying to return a value based on criteria between two spreadsheets I am looking for an excel formula … read more
Jess M.
Computer Support Specialist
Bachelor's Degree
1,100 satisfied customers
Sumif/Vlookup Across Multiple Workbook I am currently using
Sumif/Vlookup Across Multiple WorkbookI am currently using Office 2019 and I have a multiple (more than 50) workbooks , each are individually named by date and I have about different Suppliers that I … read more
Jess M.
Computer Support Specialist
Bachelor's Degree
1,100 satisfied customers
Can anyone help with a fairly simple Excel problem? I've
Hi! Can anyone help with a fairly simple Excel problem? I've tried throughout the net and forums, but no success....… read more
Russell H.
Computer/Electronics Consultant
2,108 satisfied customers
Would like to total a column on numbers, I was shown the
would like to total a column on numbers, I was shown the formula, but I don't know how to start and type the formula … read more
PC_Wizzard
IT Technician
1,367 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
Freelance IT Consultant
870 satisfied customers
Excel formula needed: At cell A1 I have value that is
Excel formula needed: At cell A1 I have value that is constrained by a data validation list so that the values are always consistent. I would like to have a formula create for cell B1 that does a look… read more
Bruce Wilner
Master of Engineering
33 satisfied customers
Here is the model Source Table: Column A (Name) Column
Here is the model Source Table: Column A (Name) Column B (Score) Gil Gibori 5 Carrie Gibori 3 Gil Gibori 8 Value table: Column A (Name) Column B (Sum) Gil Gibori 13 Carrie Gibori 3 Formula: = SUMIFS('… read more
Bhavik Joshi
Computer Science and Engineering
1,190 satisfied customers
Ok so in column A I have different variables but with the
Ok so in column A I have different variables but with the same formula. I.e. A1 is 1.5*1000/29.57/1.5 , A2 is .7*1000/29.57/1.5 how do I create a formula for the entire column but with changing the ce… read more
Zabo04
Master\u0027s Student
Master's Degree
173 satisfied customers
Is there a date function that returns today's date
Is there a date function for Excel that returns today's date in the cell when the cell is clicked on?… read more
Jason Jones
AAS Information Technology
12,783 satisfied customers
,I have 2 columns, I need to sum the values in column
Hello, I have 2 columns, I need to sum the values in column B based on the value of column A. The problem is I have 200000 cells. Here is an example 1215 1000 1215 1200 1215 1023 2116 50 2116 75 2116 … read more
Jess M.
Computer Support Specialist
Bachelor's Degree
1,100 satisfied customers
I HAVE 2 COLUMNS WITH NUMBERS IN THEM SAY COLUMN A AND COLUMN
I HAVE 2 COLUMNS WITH NUMBERS IN THEM SAY COLUMN A AND COLUMN B, I NEED TO HIGHLIGHT ALL THE NUMBERS RED OR BOLD THEM THAT ARE IN COLUMN B.… read more
Josh
It Support Specialist
Associate Degree
8,371 satisfied customers
I would like to input values in a column, and have a count
I would like to input values in a column, and have a count display in another column based upon the date. For example: Using a function if I place a 5 in A1 through A5 at 11:55pm I want column =sum(A1… read more
Richard
IT Manager
IT Manager, Consultant
16,935 satisfied customers
I have multiple columns of numbers and I want to directly compare
I have multiple columns of numbers and I want to directly compare the number across a given row. So, say I have numbers in column A, B & C. I want to do a filter that will tell me if the value in C1 i… read more
Jess M.
Computer Support Specialist
Bachelor's Degree
1,100 satisfied customers
I need if statement of some sorts 3 Column(s) of data below.
I need if statement of some sorts 3 Column(s) of data below. If any data appears in Column C it override(s) column A & B. And Column B overrides column A. If no data appears in Column(s) B & C default… read more
Jess M.
Computer Support Specialist
Bachelor's Degree
1,100 satisfied customers
I have two ranges of information, given that a criteria is
I have two ranges of information, given that a criteria is met in range B, I want to count the number of matches in range A....… read more
Jess M.
Computer Support Specialist
Bachelor's Degree
1,100 satisfied customers
I use Excel in Office for Mac 2011... I have no problem summing
I use Excel in Office for Mac 2011... I have no problem summing a number of columns to a single column. However, I work with worksheets that have a number of rows, ranging from 6,000 to 45,000, and dr… read more
Nalosin
Computer Support Specialist
High School or GED
1,024 satisfied customers
I want a formula that looks for a text string in a cell and
I want a formula that looks for a text string in a cell and if it finds that text string return a certain text string. So if cell A1 contains "Waitrose" or "Tesco" or "Sainsburys" or "Asda" return "Su… read more
John D
Bachelor Degree in Engineering
140 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.

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.
...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.

Computer Support Specialist

1,100 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

Computer Manager

751 satisfied customers

20 years experience providing remote computer support

Kamil Anwar

Office Specialist

363 satisfied customers

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

James K.

Consultant

298 satisfied customers

Technical Director of IT Company

Shefin

Microsoft Office Specialist

208 satisfied customers

Working as Tech support specialist with a world famous computer manufacturer

IT Miro

Computer Scientist

193 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Support Specialist

174 satisfied customers

Certified Expert with over 10 years experience.

< 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