is there a function

[ksnapp]

that will tell me the row something occurs in

Lets say I have a list of nave in column A and and i need to know th
row number that "BOB" occurs in

bill
bob
john
jeff

supposing bill is in a1 i need a function that will tell me 2 as a
answer

 

[Vasant Nanavati]

=MATCH("bob",A1:A100,0)

 

[Gord Dibben]

And for the second question.

=COUNTIF(A1:A100,"bill")

Gord Dibben Excel MVP

=MATCH("bob",A1:A100,0)

 

[Vasant Nanavati]

There was a second question? <g>

Regards,

Vasant.

And for the second question.

=COUNTIF(A1:A100,"bill")

Gord Dibben Excel MVP

 

[Gord Dibben]

Vasant

I originally thought so, but looking at it again.......I'm not so sure.

The "2" could be the row number or the number of "bills" in the list.

Gord

There was a second question? <g>

Regards,

Vasant.