Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Counting unique values in a column

Hello,
I have column in a Numbers spreadsheet that contains around 5000 values (they are ip addresses e.g. 155.69.160.78). There is one value per row. I need to count the number of unique addresses in the column. How can I do this please?
KE

Mac OS X (10.5)

Posted on Apr 22, 2008 3:33 AM

Reply
Question marked as Best reply

Posted on Apr 22, 2008 6:08 AM

kemamy,

Create a supplementary column with the formula: =IF(COUNTIF(A$1:A1, A2)=0,1,"") Then sum this column.

pw

User uploaded file
2 replies

Counting unique values in a column

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.