Advanced Filter

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I used advanced filter to combine duplicate rows into a unique row. However,
the duplicate rows are still there. If you go to the Data menu and click
Show All, the duplicate rows are displayed again.

My question is, after filtering out the duplicate rows, how do I get rid of
them, not just hide them?
 
Greg,

Use "copy to" instead of "filter in place." The copied-to is your unique
list.
 
Back
Top