How to find highest number in a column

I wondered if someone could help me?

I need to find out the highest number in a column of figures, however if the column has the same number in multiple cells it needs to look at the column adjacent to it to which is high than the other. Plus there are names in the first column which I would need to link, hope this is clear 

Here is an example

Col A Col B Col C

Name Pounds Ounces

Clive 2 10
Tom 3 10
Charlie 3 8
Nick 2 14
Sam 1 15



Highest would be Tom 3 pounds 10 ounces

Can anyone help?

One way, avoiding using array formulae, is to put this formula in D1:

=B1+C1/16

and copy down. Then you can find the name using this formula:

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

Hope this helps.

Pete

Originally Posted by XOR LX

Actually, a single-cell solution doesn't have to be an array formula:

=INDEX(A2:A1000,MATCH(MAX(INDEX(B2:B1000+C2:C1000/16,,)),INDEX(B2:B1000+C2:C1000/16,,),0))

Regards

Hello,

This works great thank you for your help, including everyone else who contributed

If I wanted to copy the formula but leave the name column as a constant, how would I change it I have tried using $ but cannot get it to work. This is the formula I currently have


=INDEX(A5:A33,MATCH(MAX(INDEX(J5:J33+K5:K33/16,,)),INDEX(J5:J33+K5:K33/16,,),0))

Plus, if I want to put the weight that corresponds to the name below it would I need to use a VLOOKUP as suggested by benishiryo

Thanks

Thanks, that's better, I had put the $ signs in the wrong place. I just needed the constant around the 'A' Columns

Regards

Diane