Mode - IF?

C

Crosswire

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!
 
B

Biff

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
 
Top