Ken,

That formula only seems to work if the max value in column b is highest
on the list for coresponding values in column a.


--
kwrohde
------------------------------------------------------------------------
kwrohde's Profile: http://www.excelforum.com/member.php...fo&userid=5721
View this thread: http://www.excelforum.com/showthread...hreadid=549456