| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the row no of the lowest non-zero cell in a range
Good morning all,
Can anyone suggest a quick way of returning the row number of the lowest cell in a range (e.g. B10:B25) that contains a non-zero value? I thought of a nested loop where the value of each cell is tested and the row number stored is to a varable if it is greater than the value already stored there, but this needs to be part of a worksheet_change macro and it might slow things down too much doing things in this way. Thanks in advance Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about returning some values from highest to lowest | Excel Discussion (Misc queries) | |||
| Looking up a named range and returning value into a cell | Excel Discussion (Misc queries) | |||
| looking for another same value cell in a range and returning a coresponding value | Excel Worksheet Functions | |||
| Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
| How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions | |||
Threaded Mode
