Creating an Advanced Filter

When you create a filter using AutoFilter, you can create complex rules to filter the contents of the worksheet. The limitation is that the rules used to filter the worksheet aren’t readily discernable. If you want the rules used to filter a column’s values to be displayed in the body of the worksheet, you can write each rule in a cell and identify those cells so Excel knows how to filter the worksheet. If you ever want to change the rules used to filter your data, all you need to do is change a rule and reapply the filter.

Build an Advanced Filter

  1. Copy the column titles of the list you want to filter.

  2. Paste the titles in another spot on your workbook.

  3. Under their respective titles, type the criteria you want met.

  4. Select a cell in the list you want filtered.

  5. Click the Data tab.

  6. In the Sort & Filter group on the ribbon, click Advanced.

  7. Click the List Range box.

  8. Select the entire list you want to filter, including the column headers.

  9. Click the Criteria Range box.

  10. Select the cells on which you want to base the filter, including the column headers.

  11. Click OK.

    Tip

    Tip

    Select the Copy To Another Location option to specify a range of cells into which you want the filtered list copied.

    Tip

Remove an Advanced Filter

  1. Select the cells from which you want to remove a filter.

  2. Click the Data tab.

  3. In the Sort & Filter group on the ribbon, click Clear.

    Remove an Advanced Filter
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.142.12.207