Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use row numbers from a list in subsequent formula
Is there a straightforward way to scan thru a column and identify each row
numer that contains a specific value in the column? The column is not in any sort sequence. I waant to use the row numbers obtained as input to a formula afterwards. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
use row numbers from a list in subsequent formula
You could use MATCH
For example: =MATCH(B1,A:A,0) looks for the value in cell B1 in the cells in column A and returns the relative position. So, if you had a, b, c, d, e, ... in cells A1, A2, A3, A4, A5, ... and c in cell B1 it would return 3 If there are multiple cells with c in them it would be more complex ... and the answer might depend on how you wanted to see the output. Regards Trevor "carl43m" wrote in message ... Is there a straightforward way to scan thru a column and identify each row numer that contains a specific value in the column? The column is not in any sort sequence. I waant to use the row numbers obtained as input to a formula afterwards. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format from a list of numbers | Excel Discussion (Misc queries) | |||
How to identify a list of numbers as a publisher field | Excel Discussion (Misc queries) | |||
list formula for dates | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |