Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]() Hi Anne, Thats great! Thanks for the tip. Cath -- cathcarr1 ------------------------------------------------------------------------ cathcarr1's Profile: http://www.excelforum.com/member.php...o&userid=25184 View this thread: http://www.excelforum.com/showthread...hreadid=386725 |
#4
![]() |
|||
|
|||
![]()
So you don't care that it doesn't answer the question asked???
-- Regards, Tom Ogilvy "cathcarr1" wrote in message ... Hi Anne, Thats great! Thanks for the tip. Cath -- cathcarr1 ------------------------------------------------------------------------ cathcarr1's Profile: http://www.excelforum.com/member.php...o&userid=25184 View this thread: http://www.excelforum.com/showthread...hreadid=386725 |
#5
![]() |
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |