FILTERING PRICELISTS
 

i am working with a pricelist. the first column contains codes and each code may appear several times. i want to filter the list in place so that each code appears only once. i have tried the advanced filter option, but what it does is that if a code for example appears five times and i opt for unique records only, it then appears four times. how could i filter the list so that each code appears only once?

FILTERING PRICELISTS
 

When you filter the list, select only the cells in the first column as
the List Range. For example:

Range("A1:A500").AdvancedFilter _
Action:=xlFilterInPlace, Unique:=True


angie wrote:
i am working with a pricelist. the first column contains codes and each code may appear several times. i want to filter the list in place so that each code appears only once. i have tried the advanced filter option, but what it does is that if a code for example appears five times and i opt for unique records only, it then appears four times. how could i filter the list so that each code appears only once?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html