Using the Advanced Filter function to filter data in Excel is easy and powerful

Edited screen shots showing how to use advanced filter in Excel to filter data