finding row of maximum number

birdman

Board Regular
Joined
Oct 11, 2005
Messages
187
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.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
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.
 

dgpenny

New Member
Joined
Jan 1, 2004
Messages
46
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

Well-known Member
Joined
May 19, 2002
Messages
2,916
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,738
Members
412,482
Latest member
arooshrana2
Top