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 » Advanced filters
Advanced filters
Resolved · Low Priority · Version 2007
Carol has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Advanced filters
Does the filter keep to subject as well as ascending??
RE: advanced filters
Hi Carol, Thank you for your post, welcome to the forum, in answer to your question headed Advanced Filters, Filtering a database enables you to find and work with a subset of the data. Filtering displays only the rows that contain a certain value or that meet a set of criteria whilst hiding other rows. Excel provides the AutoFilter and the Advanced Filter commands to filter your data.
AutoFilter meets most needs.
However when you need to use complex criteria to filter a list or copy data elsewhere, use Advanced Filter.
For best results your list should have column labels.
When you require filtering meeting specific needs; for example; a Custom AutoFilter could be used to display records that contain either one value or another. A Custom AutoFilter could also be used to display records that meet more than one condition for a column, such as records that contain values within a specific range (such as values between 25 and 100).
The Advanced Filter command enables you to find rows using more complex criteria, as well as extracting information to a different location (rather than filtering in place), Before using Advanced Filter, you must set up a separate criteria range and enter the criteria required. The resulting filtered information will display in the same format as the original data.
To activate the Advanced Filter command: On the Data ribbon locate the Sort and Filter section, Click Advanced, From the dialog box, select your original data range, your Criteria range and finally the first cell of the range where you wish your filtered data to appear. I know this has been a fairly long answer to your question, but I felt it was necessary to cover the subject. If you are happy with the answer, please click the Resolved Link.
I hope it has helped. best regards Pete.
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:Adding a comment to a formula1. At the end of the formula, add a + (plus) sign.
|