Mode - IF?
 

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

Mode - IF?
 

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

Mode - IF?
 

Thanks Biff, worked perfectly!


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