C
cmiedaner
I am trying to learn how to pull a list of unique items
that have defined characterisitics from a larger list.
that have defined characterisitics from a larger list.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I
Immanuel
Take a look at the Advanced Filter. Online Help should give you an example
of how to use it.
/i.
of how to use it.
/i.
D
David Hager
G
Guest
Thanks all.
When I look at the list I want to select unique items that
are subject to my defined criteria.
For example. I have my column 'master list' that has 4
Product Groups (Product A, ProductB, ProductC, ProductD).
Then I have a second column list that contains 3 columns,
Product Group, Product, Sales.
What I would like to do. For each of the 4 Product Groups
I would like to list out the Product that had the greatest
Sales. In the case where Sales are equal for a given for 2
Products in the Product Group, I do not care witch Product
is selected for the list.
When I look at the list I want to select unique items that
are subject to my defined criteria.
For example. I have my column 'master list' that has 4
Product Groups (Product A, ProductB, ProductC, ProductD).
Then I have a second column list that contains 3 columns,
Product Group, Product, Sales.
What I would like to do. For each of the 4 Product Groups
I would like to list out the Product that had the greatest
Sales. In the case where Sales are equal for a given for 2
Products in the Product Group, I do not care witch Product
is selected for the list.
J
Jim
Data>Filter>Autofilter. In each category, click the arrow and choose Custom,
where you may enetr criteria.
where you may enetr criteria.