How to Count Unique Values in a Column

hi all, I could use some assistance. I want to be able to count the values in a column that are UNIQUE ONLY. See example below:

Column A = GREEN
Column A = BLUE
Column A = GREEN
Column A = RED

i want to be able to return a value of 2, not 3. I don't want to count the value GREEN at all.

Any help is much appreciated!!!!

place this in a direfent column than A for every entry. at the top of that column the add the 1s.
=IF(COUNTIF(A:A,A4)>1,0,1)

Originally Posted by Ace_XL

Try

=SUMPRODUCT(1/COUNTIF(A1:A4,A1:A4))

This is giving me an error of dividing by 0

=SUM(SIGN(FREQUENCY(IF(COUNTIF(A1:A4,A1:A4)=1,MATCH(A1:A4,A1:A4,0)),MATCH(A1:A4,A1:A4,0))))

Ctrl+Shift+Enter, not just Enter

worked...thanks everyone!!!!!

You're Welcome!

Originally Posted by saint01

worked...thanks everyone!!!!!

For the benefit of others that might peruse this thread ... what worked for you?