98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Filter
Advanced Filter
Resolved · Low Priority · Version 2003
Eliska has attended:
Excel Intermediate course
Excel Advanced course
Advanced Filter
What is complex criteria?
RE: Advanced Filter
Hi Eliska,
Thank you for your post, in answer to your question, Complex Criteria is a reference to more than one set of query, ie a mixture of AND and OR.
This would require more than one set of criteria from different columns of data, ie from one column a value higher than x and from another a value equal to or less than x.
This is usually accomplished by creating a separate table with all your required criteria entered and then refering to that table in your Advanced Filter dialog box.
I hope that has answered your question, regards Pete
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. |
Excel tip:Showing all menu itemsIf you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items. |