Newest Excel Questions | Wyzant Ask An Expert

197 Answered Questions for the topic Excel

Excel Microsoft Excel

03/20/19

How do I protect my Excel spreadsheet?

Follows • 1

Answers •1

Excel Microsoft Excel

03/19/19

Can you transfer data from one Excel sheet to another using a ‘vlookup’ and have a function contained that will enter the data into the correct field?

Follows • 1

Answers •1

Excel Microsoft Excel Accounting Symbols

03/19/19

Divide entire column in excel (accounting) in 2 separate column (symbol + value)?

how to divide excel field with format accounting omitted, for example: $ 220 € 140 $ 220 € 140 $ 220 € 140 $ 220 € 140 etc...etc... So, from one field-column A, to get 2 column A (for accounting... more

Follows • 2

Answers •2

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