Counting # of Colors in a Column?
 

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

Counting # of Colors in a Column?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Michael wrote:
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