Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Excel
|
|
|
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. |
excel+courses - Excel
Resolved · Low Priority · Version Standard
Reply Tue 29 Jan 2008, 14:08Delegate Roxanne said...
Roxanne has attended:
Excel Intermediate course
Excel
What is the difference between advanced filters and normal filters?
For upcoming training course dates see: Pricing & availability
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
|