D
Driftwood
Hello,
What I'm looking for is (without creating a pivot table):
In Column Q:
List all customers - only once and no empty rows- that appear in column B
from row 10 through row 2000.
For more information on my sheet setup, please read below.
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 (without creating a pivot table):
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
What I'm looking for is (without creating a pivot table):
In Column Q:
List all customers - only once and no empty rows- that appear in column B
from row 10 through row 2000.
For more information on my sheet setup, please read below.
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 (without creating a pivot table):
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