Create Custom Filters Using Excel Advanced Filter
If Excel Autofilter isn't satisfying your filtering needs, then Excel's Advanced Filter feature is what you need. In this free tutorial, TrainSignal's Bill Kulterman shows you how create an advanced filter to locate employees in a list based on multiple criteria.