Identifying the largest value

[tugmbawk]

I need help creating a formula identifying the row with the largest value from a second column of data

A B C
215591 0
215592 0
215593 0
215594 0
215595 0
215596 0
215597 0
215597 1
215597 2 [Select this row as the series with the highest value in column B]

anyone?

[daddylonglegs]

Try

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

If you want to find the value in A which corresponds to the Max value in B try

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