Try this, Cath:
http://www.officearticles.com/excel/...ft_excel.h tm

*******************
~Anne Troy

www.OfficeArticles.com


"cathcarr1" wrote
in message ...

Hi there,

I have some data a bit like this:

Column A Column B

customer1 red
customer1 red
customer2 red
customer2 blue
customer1 green
customer2 green
customer3 green

I want to know how many different customers appear in column A for each
colour in column B. For example, there are 2 different customers in the
list for red, 1 customer for blue, and 3 customers for green.

I am sure there is a perfectly simple way to do this, but it has me
stumped today!

Many thanks,

Catherine


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