List of Unique Items

[cmiedaner]

I am trying to learn how to pull a list of unique items
that have defined characterisitics from a larger list.

 

[Immanuel]

Take a look at the Advanced Filter. Online Help should give you an example
of how to use it.

/i.

 

[David Hager]

See:

http://www.j-walk.com/ss/excel/eee/eee004.txt

 

[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.

 

[Jim]

Data>Filter>Autofilter. In each category, click the arrow and choose Custom,
where you may enetr criteria.