Try this:

=MATCH(MAX(IF($A$1:$A$5="Peter",$B$1:$B$5,0)),$B$1 :$B$5,0)

This is an array formula. It should be entered with CTRL-SHIFT-ENTER
instead of just Enter. If done properly, the formula should be enclosed in {
}

HTH,
Elkar


" wrote:

Anyone knows how to find the max value in one column where the value
in another column match a particular search criteria. The sheet looks
something like this:

A B
Peter 5
James 3
Peter 7
James 6
Peter 2

I need to find the row with the highest number for Peter. Finding the
row (row 3) would be the best, but finding the number (7) could also
do because the numbers are almost certainly unique.

Thanks in advance.