If I have a 2 columns of data like this:

Col A Col B
a 1
b 2
c 8
a 5
b 6
c 1

What is the best way to retrieve the maximum entry in Col B for a
specific entry in Col A.


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