microsoft excel training day courses near kent - Advanced filter

Hi Maurice

Thank you for your question, and apologies for the delay in replying.

To create an advanced filter, you need to have criteria set up so that Excel knows what to show in the filter results.

The criteria consists of the heading of the column you are getting Excel to look in; and what value you want it to find in that column. You can have multiple headings and values as part of your criteria.

For a simple and illustrated example of how to set up an advanced filter please see http://www.contextures.com/xladvfilter01.html

I hope this helps.
Amanda