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