excel+courses - 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