Tell me more ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.
up vote 3 down vote favorite

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

share|improve this question
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

2 Answers

up vote 4 down vote accepted

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.

share|improve this answer
2  
Works great! Thank you. – Graphic Agenda Jul 7 '12 at 23:27
Your Welcome! :) – kevin9794 Jul 12 '12 at 18:56
up vote 1 down vote

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.