Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Advanced filter
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel training day courses near kent - Advanced filter
Resolved · Low Priority · Version Standard
Reply Thu 6 Dec 2007, 17:03Delegate Maurice said...
For upcoming training course dates see: Pricing & availability
RE: 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
|