| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find a value and count the rows back to the reference row.
I have a column of random numbers and need to find, from a specific row
forward, the first number that is = than the number in the reference row. Then I need to know how many rows away from the reference row (excluding empty rows) that number was found in. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I switch from 1,2,3... back to A,B,C... column reference na | Excel Discussion (Misc queries) | |||
| How do you change Cell name reference from R[-2]C[-1] back to C2 | Excel Discussion (Misc queries) | |||
| Find and Count Frequency of Numeric Value in Non-Contiguous Rows | Excel Worksheet Functions | |||
| Macro to: Find a Reference, and then Paste into the 10 Rows Below | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of Numeric Value and Count BACK to Previous | Excel Worksheet Functions | |||
Threaded Mode
