(4) The filter result is the wanted result. Shown as follows:
14 Filtering result
If you want to restore the filtered data, you can select Show All in the Sort and Filter drop-down list.
Then all the data will be displayed.
220.127.116.11.2 Advanced Filter
The Advanced filter lets you use complex criteria to filter a range. And the filter result can be
displayed in the original worksheet. The rows that don’t meet the criteria will be
hidden. The filter result
can also be displayed in a new location.
Operation steps are shown as follows
(1) In the Editing group, select Advanced Filter in the Sort and Filter drop-down list. The
Advanced Filter dialog box pops up:
15 Advanced Filter dialog box
Filter the list, in-place: hide data rows that don't fit the filter condition. And display the
filter result in the original worksheet.
Copy to another location: copy the data rows that fit the filter condition to another location.
But the data rows that don't fit the filter condition will remain in the original worksheet and
won't be hidden. By doing that, it's very convenient to compare the data.
(2) Click Copy to another location , and check Unique records only . Shown as follows: