| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding non zero value in a group of cells
I have a monthly list of Selling Prices by part that I want to use a formula
on to retrieve the most recent price. The problem occurs when the last month(s) in the list has no sales and thus no sellng price. See Below: Sep Oct Nov Dec Part A 4 4 4 3 Part B 2 2 I can't use 12 If Statements to say "If Dec is 0, use Nov, If Nov is 0 use Oct, etc". What formula can I use that will go backwards (In this case Dec backwards) until it finds a value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| Finding the latest date represented in a group of cells | Excel Discussion (Misc queries) | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| Finding days between cells C and L where the cells may be empty | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
