| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW? Find and display the last cell in a column with a value 0
I want to create a formula in a cell that will make that cell display the
value of the last cell in a column with a value greater than 0. i.e.: A B C D E 1 500 <---- 2 3 17 4 75 5 500 <---- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| find value in column F, then display value in column A of that row | Excel Worksheet Functions | |||
| find the largest value in column, put in a cell | Excel Discussion (Misc queries) | |||
| how to display the column or cell the MIN() result came from? | Excel Worksheet Functions | |||
| can excel find the last used line in a column and display it? | Excel Worksheet Functions | |||
Threaded Mode
