7 Answered Questions for the topic worksheet function

Worksheet Function Microsoft Excel

07/30/19

How do I get the day name into a cell in Excel?
Given a date, how do I get the day of the week (e.g. "Monday") into a cell in Excel?
Follows • 1
Expert Answers •1

07/30/19

Create a pie chart from distinct values in one column by grouping data in Excel?
I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).How can I make Excel group all the distinct values together and then display... more
Follows • 1
Expert Answers •1
Worksheet Function Microsoft Excel

07/29/19

How do I hide the #DIV/0! error while a referenced cell is blank?
In Column C I have Production. In column D I have Goal. In Column E I have variance %. My formula is `=(D11-C11)/D11`However, how do you hide the cells down the sheet until you put something in... more
Follows • 1
Expert Answers •2
Worksheet Function Microsoft Excel

07/17/19

How to compare two columns and find differences in Excel?
I have two columns in Excel that I want to compare and find the differences between them.Suppose: - Col A has 50 numbers, i.e. 0511234567 - Col B has 100 numbers in the same format
Follows • 4
Expert Answers •3
Worksheet Function Microsoft Excel

07/15/19

What does "A1:A4^{1,2,3}" mean in an Excel formula?
What does the caret operand in Excel do to a range when it is followed by some other numbers in brackets? For example lets say we have the following table: A B C 1 1.5 0 0... more
Follows • 1
Expert Answers •1
Worksheet Function Microsoft Excel Accounting Excel

06/13/19

Find Excel three-columns match in two different sheets?
I've three sheets from differents periods of several companies It happens that not same accounts were used on all periods. I need to compare two or three companies from two different periods. I've... more
Follows • 2
Expert Answers •1
Worksheet Function Microsoft Word Latex

05/29/19

Type math formulas in Microsoft Word the LaTeX way?
I wonder if there is some free solutions for typing math formulas the LaTeX way in Microsoft Word document (Office 2007)?
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.