Diagram of differences between two ways to select non-duplicate records in an Excel advanced filter

Two different ways of selecting non-duplicate records in advanced filtering in Excel There are two ways to display filter results in an existing area to copy the filtered results to another location in an existing area show filtered results filtered rows are only hidden. The second way to copy the filter results to another location Filtered rows are already deleted

Select the data area to observe that there are two rows in this range that have duplicates and appear twice, and are next to each other.

Mouse Click A1 cell drag mouse to E25 cell release mouse

Click on the menu bar Data Filter Advanced Filter command

In the way of the Advanced Filter dialog that pops up, select to copy the filter results to another location click the blank box at the back of the copy location and then point to the G1 unit Geshing Select not duplicate record click OK

You can observe that the results of the replication are two lines short and the two lines that appear in the original area twice.

Select A1 to E25 this area again by menu bar Data Filter Advanced Filter the way in the Advanced Filter dialog that pops up. Display filter results in an existing area check to show no duplicates click OK

See the two lines that show the results repeat, there's only one line left, no duplicates, and there are two hidden rows. In fact, the rows of two hidden rows are repeated respectively.