thanks, but my problem is that the colours are repeated and i dont want it to
count a colour twice


"Anne Troy" wrote:

Try =CountA(C2:C65536) or something like that, mahmon.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"mahmon" wrote in message
...
I have databse of products, one colum contains text values for the colours
these products are, red, green , blue, etc. what functinocan tell me how
many
colours are in the column? help please