FILTERING PRICELISTS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top