I'm trying to figure out how to calculate
unique entries on a list in Numbers:
Fx:
Coca Cola
VB
Brunt
Coca Cola
Modern talking
Coca Cola
Coca Cola
Modern talking
It has:
Total entries: 8
Unique entries: 4
Total entries is simple with the COUNTA,
but I just can't figure out how to count the
unique entries.
Hope any one can help.
(Sorry no screen dump, couldn't press insert
for some reason)
iMac, Mac OS X (10.7.2)
This uses COUNTIF, and COUNTBLANK:
B2=A2
B3=IF(ISBLANK(A3), "", IF(COUNTIF($B$2:B2, "="&A3)=0, A3, ""))
select B3 and fill down as needed
F2=COUNTA(A)
F3=ROWS(F)-COUNTBLANK(B)
This uses COUNTIF, and COUNTBLANK:
B2=A2
B3=IF(ISBLANK(A3), "", IF(COUNTIF($B$2:B2, "="&A3)=0, A3, ""))
select B3 and fill down as needed
F2=COUNTA(A)
F3=ROWS(F)-COUNTBLANK(B)
Hi Wayne
Super thx for reply. Much appreciated. I had hoped for one formular without extra calculative rows involved.
Have been able to produce the very same count as you.
Thanks for the screen shot. It helped a lot too.
Jakob
Jakob,
You can move the "extra" columns to another table and place the table "out of the way" OR you can hide the extra column by clicking on the contextual menu for that column and selecting "Hide Column"
Count in Numbers - Unique entries on a list
