List any duplicates once

[Driftwood]

Hello,
My sheet setup is:
-Row 1-10 are empty cells & macro buttons-
-All column have autofilter starting in row 10-

Column A: Dates of orders starting from 1/1/09 - YTD (duplicates no problem)
Column B: List of customer names (customers appear more than once)
Column I: Amount of the invoice for orders ($$)
Column L: Month&CustomerName like:"7SmithRubber"

What I'm looking for is:
Column Q:
List all customers - only once - that appear in column B from row 10 through
2000
Then I can do a SUMTIF:
SUMIF(B:B,Q1,I:I) per customer YTD and another per customer - per month.

I would like to eventually have this as a template, as the customer names
will constantly be changing/updated, so I never know who's name will be added
- or omitted from column B - that's where I'm struggling with the listing a
customer only once.

Thanks
Driftwood

 

[Herbert Seidenberg]

Excel 2007 PivotTable
http://www.mediafire.com/file/tz3tmzmgmqk/07_30_09a.xlsx

 

[Driftwood]

Sorry I could not get back to this site sooner - I just got back into work
today.
Thank You Herbert for replying to me request for help. However, I do not
want to use a Pivot table (from the header of your reply) and also I am
blocked from this site that is linked - I'm lucky I can be on THIS site -
because I need special permissions to be on any internet site - which takes
up to two week to get permission and access from where I work.