Counting Unique Values in Excel

Counting Unique Values in Excel

Ran into a situation this afternoon whereby I needed to count the number of unique values in a column.

Since I find myself working in Excel, I went about searching for a solution to this.

AND… here you have it.. A quick and easy formula for working out the number of unique records in a column.
[code]=SUM(IF(FREQUENCY(D2:D13824, D2:D13824)>0,1))[/code]

Use it wisely 😉

Leave a Reply

Your email address will not be published. Required fields are marked *