finding the biggest result value for each person

A

Aline

Hi,

How do I find one of the biggest result value for everyone? If there's only
one result for the individual, the result will be automatically chosen.

Here is the example:
ID results result used
a 2 Yes
b 2
b 3 Yes
c 3 Yes
c 3
c 2
d 1 Yes
e 2
e 3
e 4 Yes
e 2

Your help will be greatly appreciated.
 
D

Don Guillett

This is an array formula that must be entered using ctrl+shift+enter. copy
down
=IF(J2=MAX(IF($I$2:$I$22=I2,$J$2:$J$22)),"Yes","")
 
Top