Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How many 'unique' customers has everyone been involved with?
This feels like it should be quite simple, but I'm really struggling...
I have a list of quotes all made by my salespeople, each one submits quotes for selling items to customers, sometimes the same customer will ask for quotes on 10 or 15 different items. for example, Fred has quoted a price (to Builders Inc) for bricks, another price for tiles, and another price for concrete, all for the same customer. These three items show up as three separate lines in my list, but each one of these three lines has the same customer name on it Fred has also quoted for other people and other sales people might have also quoted for stuff for 'Builders Inc' too So here's waht I'm after... I want a table of all my sales people, and next to each sales persons name, I just want the number of DIFFERENT customers they've quoted to, so for Fred, 'Builders Inc' must only show as one (even though it appears three times). I want a total number of unique customes that each sales person has had dealings with. I hope that makes sense Thank you M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Involved VLookup Formula | Excel Discussion (Misc queries) | |||
Involved VLookup Function | Excel Discussion (Misc queries) | |||
Percentage with a zero involved | Excel Discussion (Misc queries) | |||
Filtering Unique Customers | Excel Worksheet Functions | |||
Matching when spaces are involved | Excel Worksheet Functions |