Advanced data filtering in Excel
The following article will guide you in detail how to filter advanced data in Excel.
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:
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:
Step 3: After clicking OK, the result is:
- 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:
- After clicking OK the results:
Above is a detailed guide on advanced data filtering in Excel 2013.
Good luck!
You should read it
- MS Excel 2007 - Lesson 8: Sort and Filter
- Data filtering (Data Filter) in Excel
- Filter data in Excel with Advanced Filter
- 4 Advanced PivotTable Functions for Excel Data Analysis
- How to filter duplicate data on 2 Excel sheets
- Protecting the network through web content filtering
- MS Excel 2007 - Lesson 6: Calculation in Excel
- MS Access 2003 - Lesson 19: Filtering data
May be interested
- Sort the database in Excelinstructions 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 Excelinstructions 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 Excelguide 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 Excelinstructions 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 Excelinstructions 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 Excelinstructions 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.