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".
|