Count Unique

A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.

So here it is …

• In new column, 1st cell or the range (Say E4 as in example) paste the formula

=IF(CountIF($D$1:D3, D3)=1,"Yes", "No")

Then fill that E4 down to end of column

• Then in any cell, paste this

=CountIF(E:E,"Yes")

This way, you get a column to indicate each value in D, if it is already found above or not, then you can count the ones that were not.