Counting # of Colors in a Column?

[Michael]

Hi everyone,

Say you have an Excel column where different values are automatically
marked with a color each. So, cells that have same value have same
color and so on.

Is there a way to count how many differnt colors you have in that
column?

Regards,
Mike

 

[Frank Kabel]

Hi Mike
why don't you count the number of unique numbers?
See:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique