# Numbers: Count unique items in a column

I'd like to count the occurrence of unique items found in one column of about 120 items. I can't find a way to do this in Numbers.app

• Currently, if I do this calculation in the footer row, or another table, they both show up as "0" – Greg Kerstine Jul 5 '12 at 23:05
• Shows up as "0" because I'm not sure how to use the Count function really well. – Greg Kerstine Jul 7 '12 at 23:28

Here is a clever solution posted in an apple discussions thread.

You basically create another column, and use the formula =IF(COUNTIF(A\$1:A1, A2)=0,1,""). This will display a one for the first occurrence of each unique item. You then simply sum the whole column and you get your count.

• Your Welcome! :) – kevin9794 Jul 12 '12 at 18:56
• This is extremely slow when there's lots of data. If that's the case, you can import your data into Google Spreadsheets and use =COUNTUNIQUE(A:A) – Eugene Kulabuhov May 31 '17 at 14:04

If it doesn't have to be updated dynamically, you might also copy the cells and run something like pbpaste | sort | uniq | wc -l.

• Copy the column and run pbpaste| sort | uniq -c in a terminal. – vrypan Feb 2 '15 at 8:24
• why do you need sort? – CousinCocaine Apr 13 '15 at 17:59
• @CousinCocaine you need sort because uniq only detects repeated lines immediately following each other, not repeated lines anywhere in the input stream. See uniq man page. – Fabian Tamp Nov 20 '15 at 4:24
• You can also use sort -u instead of sort | uniq – damiankloip Feb 23 '16 at 15:43
• This one is always better than clunky gui, thanks for the reminder bro! – valignatev Jun 1 '17 at 21:09

## protected by bmike♦Feb 23 '16 at 17:03

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).