Advanced Filter

Hi Hayley

Hope you enjoyed your course

As for your question there are two types of advanced filters 1. from the drop down lists i.e. custom filters, this will let you filter to one thing or another

2. Which can be found in the data menu filter and advanced
this one is used to extract your filtered info to another place i.e. to another sheet or another location on your sheet

so to sum up the time you know when to use the advanced filters will depend on 3 things

A. you want to view certain data from parts of you data table

B. If you want to view a couple of things from your data table
i.e. to regions north & west

C. you want to extract your data from one sheet to another

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn