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?

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