• Choose one of the comparison operators

• In the Custom AutoFilter box, type or select the criteria you wish to use to filter the data

• Click OK to apply the filter.

You’ll notice that for this example we used the Between comparison filter. Your data should now look like this:

Advanced Filtering

If you want to filter data to more specific parameters, for example based on a specific criteria, or to remove any duplicate values, you can use the Advanced Filter dialog box.

Here we have a list of constituents and the regions they live in. We want to filter our list to only see the regions where we have constituents:

DATA > Sort & Filter > Advanced Filter

This will launch the Advanced Filter dialogue box. Choose Copy to another location. Select the column (in this case column A) you want to pull the unique records from.

In the Copy to: box select which column you want the unique records to be listed. (in this case we’re listing the unique records in column K)

Make sure to check the box for Unique Records Only and click OK

Our worksheet now shows only ONE of each of the areas where constituents are located in Column K where we placed the unique records:

For more information on filtering, and to try some practice exercises, login to your course and visit Section 4 “Data Handling”, Unit 1 “Sorting and Filtering”.