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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated Formula Problem 10
Filter Duplicate Records keeping record with latest date 2
Conditional Formatting Tricky question 5
Data - Filter - Advanced - Unique records only 2
Advance filter not filtering unique records only 1
Count Number of Visible Rows in Filtered View 2
How to Unfilter a List that has been filtered via Advanced Filter >Unique Records only 1
Delete duplicate rows from a list in Excel 9

Back
Top