Excel duplicate function: YOUR OBJECTIVE
You want to filter for all orders from the customer “Brack’s Windshields”, plus all orders prior to 2009 from a customer orders table. You want to save the filter results so that you can review them any time later. The Excel 2010 advanced filter allows you to save the filter results in a cell range outside the original table.
This learning module “Excel duplicate function” will show you how to do this in Excel 2010.
Excel duplicate function: HOW DOES IT WORK?
The advanced filter can be used after you have created a criteria table outside the table you want to filter.
Define the range to be filtered here. Excel usually recognizes the range automatically. It requires, however, that the active cell is in the range of the original table when applying the advanced filter. If not, click in the range to be filtered.
The Criteria range: must be selected manually and refers to the criteria table you have created.
This field only becomes active when you have selected the Copy to another location option above. Define the cell range to which you want to copy the resulting table with the Copy to: function.
Select this option to hide any duplicates.