| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find first value in range
I'm trying to do the following:
Offset(A15, ____, -5) where _____ is a function that says look at the range (B3:B20) and return a reference to the first value that is greater than zero. I'd rather not create vba code behind it, but will if I have absolutely have to. Is there any way to see what is the first value in a range that is greater than o? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
| Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| I need a formula to find rows within a date range in one column? | Excel Worksheet Functions | |||
Threaded Mode
