| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return row # of a certain cell
Ah yes, appreciate it
"Ron Coderre" wrote: Try something like this: If the search word will only be in ONE column: Example: Find the row containing "Run" in Col_F =MATCH("Run",F:F,0) If the search word may be in a range: Example: Find the row containing "Run" in E1:G1000 =SUMPRODUCT((E1:G1000="Run")*ROW(E1:G1000)) Note: Those formulas presume the search term will only occur once. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Chris" wrote: Is there a way to return the row # of a cell without using the cell's location but rather its content? For example, I would like to return the the row # of a cell that contains the word "Run". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Return value in cell above the reference | Excel Discussion (Misc queries) | |||
| help with index to return particular cell value | Excel Discussion (Misc queries) | |||
| How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
