Excel advanced filters

Excel advanced filters
8 May 2013

Advanced Filters have a couple of advantages over regular filters:

  • The filter criteria is contained on your worksheet so you can easily see what filters are applied. Whereas with AutoFilter you have to click on the down arrow to see what filters have been applied.
  • Advanced Filters allow you to extract your filtered data to another place in your worksheet/workbook or extract a unique list of records.

Their downside is it's not as obvious that your data is filtered since they don't display drop-down lists for the column headers like regular filters.