Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding cell value from top of a list greater than 0
I am trying to find a formula which will return a value from a list which is
greater than 0. For example, from cell AC48:AC52, I need the first number greater than 0 starting from the top. If AC48 = 0, AC49 = 100, AC50 = 20, AC51 = 0, and AC52 = 0. I need a formula to find AC49's value of 100. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List that has formatting of cell range Font ect. | Excel Discussion (Misc queries) | |||
Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
How do I set up drop-down list for a cell when the list is in ano. | Excel Discussion (Misc queries) |