finding row number?

[james]

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)


"james" <[email protected]> wrote in message
news:[email protected]...
> I would like to find the row number of a cell in column A with specific
text.
> Would any one help?
>

[Myrna Larson]

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



On Wed, 2 Feb 2005 15:47:02 -0800, "james" <[email protected]>
wrote:

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

[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