# 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" – Graphic Agenda Jul 5 '12 at 23:05
Shows up as "0" because I'm not sure how to use the Count function really well. – Graphic Agenda Jul 7 '12 at 23:28

## 3 Answers

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.

-
Works great! Thank you. – Graphic Agenda Jul 7 '12 at 23:27
Your Welcome! :) – kevin9794 Jul 12 '12 at 18:56

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

-
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

Copy the column and run `pbpaste| sort | uniq -c` in a terminal.

-