Advanced filter MS Excel

Advanced filter option in MS Excel allows to fast filter data in your worksheet. Option available under Advanced filter are Criteria range and list range. Optionally you have output range also.

You can combine multiple column filter with criteria range and list range includes those headings and values which are to be used for filtering.

This Guide applies MS Excel 2007 onwards

Procedure

  1. Here we are using region wise sales data. Leaving few rows after data write Criteria for Filtration of data.
    Advancedfilter
  2. Select range of Data.
  3. Click on data tab. Select advanced filter
    Advancedfilter1
  4. In advanced filter window provide List range and Criteria range. Click OK data is filtered
    Advancedfilter2
    Click here to Download Sample worksheet
  • Ione

    Superb piece of writing, I really wait for up-dates of your stuff.