Newest Excel Questions | Wyzant Ask An Expert

194 Answered Questions for the topic Excel

Excel Microsoft Excel

03/19/19

How do I split a cell in Excel into two colors?

Follows • 1

Answers •1

Excel Autocad

03/19/19

Get blocks from Autocad /Maps into excel?

I would like to get some objects on a Autocad map layer and extract their name, color and position and place them into an excel sheet in the following manner: Object Name | Color | Coordinates... more

Follows • 2

Answers •1

Excel Microsoft Excel Accounting Vba

03/19/19

VBA number formatting?

I am writing a macro package to format numbers in accounting format so that I don't have to click "alt - h - fm" every time I want to make a number accounting format (which my job requires). I have... more

Follows • 1

Answers •2

Excel Microsoft Excel

03/19/19

How do you format cells as currency in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/18/19

How do I copy a “find all” result to another spreadsheet?

Follows • 2

Answers •1

Excel Microsoft Excel

03/18/19

If VLOOKUP finds two or more matching values in a column, can it compare which one has the highest value in a specific cell and then return the value from another cell?

Follows • 2

Answers •1

Excel Microsoft Excel Accounting Formatting

03/18/19

How can I set contents of a spreadsheet cell to Accounting format with EPPlus?

I need to set the contents of certain columns to Accounting format. This attempt: public static readonly string NUMBER_FORMAT_ACCOUNTING = "$"; . . . bidPriceCell.Style.Numberformat.Format... more

Follows • 2

Answers •1

Excel Microsoft Excel

03/18/19

How do I make capital letters in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/18/19

In Excel, what is the formula to find the average summation, rank, and grade maximum and minimum value?

Follows • 2

Answers •1

Excel Microsoft Excel

03/18/19

How do you make an addition formula in Excel?

Follows • 1

Answers •2

Excel Microsoft Excel

03/18/19

What is the benefit of using Select Case over If-Then in Excel VBA?

Follows • 1

Answers •1

Excel Microsoft Excel

03/16/19

How do I convert XLSX to XLS?

Follows • 1

Answers •2

Excel Microsoft Excel

03/16/19

Is there a formula in Excel that returns the cell value of a table, by finding the column and row that meets certain criteria?

Follows • 1

Answers •2

Excel Microsoft Excel

03/16/19

What is a lookup formula in Excel?

Follows • 1

Answers •2

Excel Microsoft Excel Accounting

03/15/19

Excel - Formula is guessing wrong in Fill Down command?

I know this should be simple but I can't work it out. I have a column that is calculated with the sum of the 3 columns to the left of it. E.g. SUM(C1-C3). When I fill that down, each cell... more

Follows • 1

Answers •2