If I have a list of say

Part Qty
FFF000 1
FFF001 2
FFF000 1
FFF000 1
FFF001 2


How do I for example get the mode of the qty where Part = FFF000.

I have a list with over 5000 lines that I need a solution for!


--
Crosswire
------------------------------------------------------------------------
Crosswire's Profile: http://www.excelforum.com/member.php...fo&userid=8214
View this thread: http://www.excelforum.com/showthread...hreadid=492637