Only what you want
Excel has a tool to sort lists with a number of criteria.
Select a single cell in the table and go to Data>Filter AutoFilter.
Click on the down arrow next to the field name and choose Custom.
The illustration shows how to set up a filter that displays data between two dates.
"Some tips and techniques for working with AutoFilters, and some workarounds for problems you may encounter."
All about AutoFilters Video
Displaying AutoFilter criteria
"The Display Filter Criteria doesn't work well. It only works when after set the filter, the cell with the formula is selected. Then press F2 after that push the Enter key. Then it works. but the cell with the formula isn't updated automatically..."
# posted by W. van Dam : 7/06/2005
See all Topics