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.

=SUM(IF(FREQUENCY(D2:D13824, D2:D13824)>0,1))