LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 204
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Involved VLookup Formula andiam24 Excel Discussion (Misc queries) 3 May 31st 09 07:56 AM
Involved VLookup Function andiam24 Excel Discussion (Misc queries) 3 May 20th 09 12:20 PM
Percentage with a zero involved tankerman Excel Discussion (Misc queries) 8 March 5th 09 09:08 AM
Filtering Unique Customers vijaydsk1970 Excel Worksheet Functions 1 August 22nd 07 03:08 PM
Matching when spaces are involved JaB Excel Worksheet Functions 1 November 15th 05 12:46 PM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"