finding row number?

[Guest]

I would like to find the row number of a cell in column A with specific text.
Would any one help?

 

[Bob Phillips]

=MATCH("text",A:A,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Kevin H. Stecyk]

james wrote...

I would like to find the row number of a cell in column A with specific
text.
Would any one help?

Hi James,

Let's assume you were looking for the row number where "Stuff" is written in
text.

In cell B1....
=MATCH("Stuff", A1:A50,0)

Here I am searching for A1:A50. You can choose the appropriate range.

The result is 20. Thus, I know the row number is the 20th row of A1:A50, or
row 20.

I am not sure that is exactly what you are looking for. If not, please
provide more detail.

Hope that helps.

Regards,
Kevin

 

[Myrna Larson]

=MATCH("specific text",$A:$A,0)