Hi!
Try this:
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=MODE(IF(A2:A6="FFF000",B2:B6))
Or:
C1 = FFF000
=MODE(IF(A2:A6=C1,B2:B6))
Biff
"Crosswire" wrote
in message ...
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