formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Medium Priority · Version 2003

Lesley has attended:
Excel Intermediate course

Formulas

Can the custom auto filter work between columns

RE: formulas

Hello Lesley,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding a custom auto filter working between columns.

The short answer to your question is NO. You need to use the Advanced filter to do this.

Auto filter works on the column you select. There are various levels to using this tool, starting with a single criteria, and then onto the custom filter, where you are able to add upto two different criteria to your filter.

The limitation comes in when you want to filter between two columns. An example of this is if you wanted to show SALES deopartment from the NORTH region and ACCOUNTS from the EAST region. The custom autofilter has no way of linking the two fields (Department and Region), and so cannot separate the complex criteria. The best result you can get with Autofilter is showing all Sales and Accounts for both North and East.

Depending on your requirements, you can learn how to us the Advanced filter. Basicallty, this works just like a QUERY in a DATABASE. It is more complex to use, as it is dealing with more complex criteria. If you believe you might need to know this, please reply to this post and we can provide you with more information.


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 Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart

View all Excel hints and tips


Server loaded in 0.09 secs.