Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How many different customers in a list?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |