| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function to return the latest non-zero value in a range of cells .
I have a list of dates witten sequentially in a row on the sheet. Under some
of these I have some values. I need to find the non-blank value associated with the latest date. Is there an easy way of doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Threaded Mode
