Browsed by
Tag: count

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 😉