You are right Tom. It comes close, but doesn't actually answer the
question.

I need to be able to count the number of different customer names for
each colour. I don't want to specify particular customer names in a
formula, because there are over 1000 of them in my list.

So for example, for red there were two different customers that
appeared, and for green there were 3.

Can anyone else help?

Thx

Cath


--
cathcarr1
------------------------------------------------------------------------
cathcarr1's Profile: http://www.excelforum.com/member.php...o&userid=25184
View this thread: http://www.excelforum.com/showthread...hreadid=386725