Advanced Excel Filter (And, Or, Between conditions for criteria range)

Advanced Excel Filter (And, Or, Between conditions for criteria range)

 

How does Advanced Filter work in Excel? In this quick tutorial I show you many examples that explain: 

1. How to setup advanced filter 
2. How to use the criteria range in advanced filter
3. How to use wildcards 
4. How to setup your criteria to filter for OR / AND conditions 
5. How to filter between two dates or two numbers with advanced filter 
6. How to get a list of unique values

Related Topics:

• 3 Methods to Unhide All Sheets in Excel (and how to hide) 
• Reset Dependent Drop-down in Excel (with a tiny bit of VBA) 
• 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa) 
• Excel Custom Formatting with Thresholds and Icons: Quick and easy