calculating multiple mode values in Numbers
How do I create a formula to show more than one MODE value in a data set. IE> the data set has 2 or more modes
iPad, iOS 13
Question marked as
Best reply
Hi Melina,
Here's one way:
The table above has two hidden columns, one to count the occurrences of each value incolumn C, the second to index the last row containing each value with the highest count.
The rightmost column uses MATCH and INDEX to retrieve each MODE value from its indexed row.
Formulas:
D2: COUNTIF(C$1:C2,C2)
E2: IF(D2<MAX(D),"",COUNTIF(D$1:D2,MAX(D)))
F2: IF(ROW()−1>MAX(E),"",INDEX(C,MATCH(ROW()−1,E)))
Replace the commas ( , ) with semi colons ( ; ) if the comma is the decimal separator in your region.
Regards,
Barry