Overview

Filtering data in Excel can be quite advantageous, but you must build a spreadsheet with good data structure in order to take maximum advantage of the built in AutoFilter. In addition, there are certain aspects of this tool which require attention. Some things must be done ritualistically, while others are not so important. I'll go into each of the major areas which affect AutoFilter and give examples along the way.

Continue Reading: AutoFilter in Excel »