OzGrid

Excel Advanced Filter

< Back to Search results

 Category: [Excel]  Demo Available 

 

Excel Advanced Filter

 

Advanced Filter by More Than 2 Criteria

Got any Excel/VBA Questions? Free Excel Help

 

Excel Advanced Filter

Other than Excel's very popular Auto Filter, we have at our disposal Excel's Advanced Filter. In a nutshell, Excel's Advanced Filter can be used to filter by more than 2 criterion, where Auto Filter has a max of 2! It also has a very nifty feature that allows us to create a list of unique items from a list with repeated data. In addition, we can even use Excel formulas for Excel's Advanced Filter criteria.

Rules for Advanced Filtering

1) You list or table must have headings at row 1 of the table.
2) Your data must be laid out directly underneath their appropriate headings.
3) When using criteria the cell(s) directly above must have exact copies of the table heading(s). See picture below;
4) When using Excel formula criteria the cell(s) directly above must NOT have exact copies of the table heading(s). They should be blank, or have a heading that is NOT the same as your table heading(s).
5) If using the "Copy to another location" option you can only copy to the same Worksheet as your original table is located. To copy to another Worksheet you can Start by going to Data>Advanced Filter while on the Worksheet your data should be copied to.
6) To create an OR condition place each criteria in a new cell directly below each other, vertically.
7) To create an AND condition place criteria in a new cell directly next each other running left top right, escortcity.ch escort girl geneve horizontally. See picture below;

Advanced Filter Download a Workbook Showing Advanced Filter

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets.

 

See also:

Adding/Subtracting n Month(s) To/From a Date
Excel VBA Macro - Adding Values to an Excel ComboBox
Advanced Excel Dynamic Named Ranges

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


Gallery



stars (0 Reviews)