Try this array formula*:

For values in A1:B10

C1: =MAX(IF(A1:A10="b",B1:B10))

*Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter].

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=539239