finding row of maximum number

[birdman]

in cell C1 i would like to find the row of the maximum number in column B . for example, if the maximum number in column B is located in B200, i would like C1 to have a value of 200. does anyone know the formula to do this?? thanks for any help in advance.

 

[Seti]

How about something like this:

=MATCH(MAX(B:B),B:B,0)

It will only find the 1st one in the event of a tie.

 

[birdman]

works great. thanks for the help.

 

[dgpenny]

Similar question

I want to do almost the same thing. I want to check column B for the highest value, but also return the corresponding value in column A, which has the date the highest value occurred.
Thanks.

 

[Seti]

Try this:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Again, the 1st occurrence will be used in the event of a tie.