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 » excel+courses - Excel
excel+courses - Excel
Resolved · Low Priority · Version Standard
Roxanne has attended:
Excel Intermediate course
Excel
What is the difference between advanced filters and normal filters?
RE: Excel
Hello Roxanne,
Hope you enjoyed your Excel training.
The Advanced Filter command on the Data menu lets you use complex criteria to filter a range, but it works differently from the AutoFilter command in several important ways.
1.
It displays the Advanced Filter dialog box instead of the Custom AutoFilter dialog box.
2.
You do not type the complex criteria in the Advanced Filter dialog box as you do in the Custom AutoFilter dialog box. Rather, you type the complex criteria in a criteria range on the worksheet and above the range you want to filter. Excel uses the separate criteria range in the Advanced Filter dialog box as the source for the complex criteria.
3.
Although you can filter a range in place, like the AutoFilter command, the Advanced Filter command does not display drop-down lists for the columns.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft APPLICATION question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
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:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |