Use implicit And and Or operators with Excel's Advanced Filter feature to create complex, but powerful, filtering combos.

Boolean logical operators in Excel formulas make searching easier, and you can apply the same methods in Internet or database searches.

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.