Advanced data filtering in Excel

The following article will guide you in detail how to filter advanced data in Excel.

Advanced data filtering in Excel Picture 1

Data Filter (automatic data filtering) allows you to filter data only on a single column or data field -> so it is limited when using data. Excel supports the Advanced Filter feature that allows you to filter data on multiple columns.

For example, if you want to filter data from Northern employees with sales greater than 3841000:

Step 1: Create a condition area outside the data table to filter -> Data -> Advanced:

Advanced data filtering in Excel Picture 2

Step 2: The Advanced Filter dialog box appears:

- List Range: Select the data area to filter:

- Criteria range: Select the container containing the conditions to filter.

- Filter the list, in place: Filter right on the original data area.

- Check the Copy to another location option if you want the filter results to show other data areas -> select the location to filter data in the Copy to -> section and finally click OK:

Advanced data filtering in Excel Picture 3

Step 3: After clicking OK, the result is:

Advanced data filtering in Excel Picture 4

- In case you want to filter many conditions on different fields, you just need to re-enter the condition area data and select the condition area again in the Advanced Filter dialog box -> OK:

Advanced data filtering in Excel Picture 5

- After clicking OK the results:

Advanced data filtering in Excel Picture 6

Above is a detailed guide on advanced data filtering in Excel 2013.

Good luck!

5 ★ | 2 Vote

May be interested

  • Sort the database in ExcelPhoto of Sort the database in Excel
    instructions on how to organize a database in excel. sorting data is indispensable when working in excel. 1. sort data simply. step 1: select the data range to be sorted - data - sort: step 2: sort dialog box appears field selection
  • Summary of data in groups in ExcelPhoto of Summary of data in groups in Excel
    instructions on how to aggregate data in groups in excel. with a large amount of data, statistical data is very complicated. here, with excel 2013, the subtotal feature helps you to aggregate data by group, giving a detailed, complete and accurate report.
  • Manipulating tables in ExcelPhoto of Manipulating tables in Excel
    guide you to create tables in excel. to create the table you perform the following steps: step 1: go to the insert - tables - table tab: step 2: the create table dialog box appears - in the where is the data for your table section select the data area to create the table - ok .
  • Table operations in ExcelPhoto of Table operations in Excel
    instructions on table operations in excel. when working with tables you should pay attention to the following: 1. edit the width of rows and columns. there are many ways to edit the widths of rows and columns. method 1: with the column moving into the vertical bar of the column - when the child
  • Manipulating tables editing in ExcelPhoto of Manipulating tables editing in Excel
    instructions to manipulate tables in excel. 1. insert rows and columns in the table: - for example, want to insert 1 column after salary column 1 day: step 1: select the column number of days - go to home - cells tab - insert - insert sheet column.
  • Format borders and background colors for tables in ExcelPhoto of Format borders and background colors for tables in Excel
    instructions on how to format borders and background colors for tables in excel. step 1: select the table you want to create a border for - design - quick styles - select the table style: light is the light color format, medium is the medium format.