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" <james@discussions.microsoft.com> wrote in message
news:04215E66-E863-4698-8DE4-575B06375413@microsoft.com...
> 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" <james@discussions.microsoft.com>
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