This will return the highest number in each group:
=LARGE(IF($A$2:$A$20=12,$C$2:$C$20),1)
12--3, 11--4, 10--4

HTH
Ola Sandström


Note: This is an Array formula, so it Must be confirmed by holding down
Ctrl and Shift, and then hit Enter. Otherwise it will return #VALUE!


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390392