# tagged [excel-formula]

#### Substring in excel

Substring in excel I have a set of data that shown below on excel. And I want to separate the data in each cell look like this. what is the function in excel that I can use

- Modified
- 16 May at 08:43

#### Get content of a cell given the row and column numbers

Get content of a cell given the row and column numbers I want to get the content of a cell given its row and column number. The row and column number are stored in cells (here B1,B2). I know the follo...

- Modified
- 14 Jan at 14:42

#### Extract the last substring from a cell

Extract the last substring from a cell I have names in a column. I need to split just the last names from that column into another column. The last name is delimited by a space from the right side. Th...

- Modified
- 7 Feb at 09:4

#### Excel - find cell with same value in another worksheet and enter the value to the left of it

Excel - find cell with same value in another worksheet and enter the value to the left of it I have a report that is generated in Excel which contains an employee's number, but not his/her name. Not e...

- Modified
- 13 Oct at 09:27

#### Sum up a column from a specific row down

Sum up a column from a specific row down It seem simple but I cannot find a way to define a range that goes up to the end of the column in an Excel formula. For instance I can use this equation SUM(C:...

- Modified
- 2 Feb at 10:6

#### Referencing value in a closed Excel workbook using INDIRECT?

Referencing value in a closed Excel workbook using INDIRECT? I want to refer to a cell value in another workbook with a formula (not VBA!). The (in the following example, C13 is "Sheet2"). If the othe...

- Modified
- 12 Apr at 08:14

#### How to apply formula to cell based on IF condition in Excel

How to apply formula to cell based on IF condition in Excel I have an Excel spreadsheed like the one shown below Column A is date and B is price of share Now my task is calculate financial return of s...

- Modified
- 5 Apr at 12:34

#### If two cells match, return value from third

If two cells match, return value from third Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Co...

- Modified
- 17 Feb at 01:13

#### Count number of occurrences by month

Count number of occurrences by month I am creating a spreadsheet with all my data on one sheet and metrics on the other. On sheet 1 in cells `A2:A50` I have the dates in this format (4/5/13). On sheet...

#### Excel: Search for a list of strings within a particular string using array formulas?

Excel: Search for a list of strings within a particular string using array formulas? I want to search a cell for a list of words. I thought this would work as an array formula: But it only finds a mat...

- Modified
- 5 May at 12:25

#### Simple Pivot Table to Count Unique Values

Simple Pivot Table to Count Unique Values This seems like a simple Pivot Table to learn with. I would like to do a count of unique values for a particular value I'm grouping on. For instance, I have t...

- Modified
- 7 Mar at 04:49

#### Combining COUNT IF AND VLOOK UP EXCEL

Combining COUNT IF AND VLOOK UP EXCEL I have multiple spreadsheets in a `workbook` and I would like the following in basic `English` talk: IF `worksheet1(cell)A3`, appears in 'worksheet2' column B - c...

- Modified
- 16 Nov at 01:54

#### How can I combine multiple nested Substitute functions in Excel?

How can I combine multiple nested Substitute functions in Excel? I am trying to set up a function to reformat a string that will later be concatenated. An example string would look like this: Though s...

- Modified
- 27 Dec at 18:40

#### In Excel, sum all values in one column in each row where another column is a specific value

In Excel, sum all values in one column in each row where another column is a specific value I'm wondering if there is an easy way to do what I'm looking for. Basically, I have a balance sheet in Excel...

- Modified
- 22 Jan at 17:0

#### Refer to a cell in another worksheet by referencing the current worksheet's name?

Refer to a cell in another worksheet by referencing the current worksheet's name? I plan to have a workbook with 24 sheets. The sheet names will be: Jan, Jan item, Feb, Feb item, etc. Basically it's f...

- Modified
- 4 Apr at 07:35

#### How to disable Excel's automatic cell reference change after copy/paste?

How to disable Excel's automatic cell reference change after copy/paste? I've got a massive Excel 2003 spreadsheet I'm working on. There are a lot of very large formulas with a lot of cell references....

- Modified
- 12 Dec at 14:23

#### Return empty cell from formula in Excel

Return empty cell from formula in Excel I need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string or a reference to an empty cell differently than a true e...

- Modified
- 28 Mar at 19:53

#### Conditionally formatting if multiple cells are blank (no numerics throughout spreadsheet )

Conditionally formatting if multiple cells are blank (no numerics throughout spreadsheet ) I have created a spreadsheet in Excel and am attempting to use Conditional Formatting to highlight a cell or ...

- Modified
- 5 Jan at 22:46