Tom’s Tutorials For Excel: Showing how Excel’s FILTER function extracts different combinations of “and” and “or” criteria records within a single formula.

by Tom Urtis 3 Comments ↓

Keywords: Excel 365; FILTER; if_empty; AND; Asterisk; OR; Plus +

Click here or the picture to download this free, safe, interactive workbook.

‹ Tom’s Tutorials For Excel: Explaining Excel’s FILTER function to extract multiple “or” criteria records, by using the plus + operator.

Posted in Tom's Tutorials for Excel
Tags: AND, Asterisk, Excel 365, Filter, if_empty, OR, Plus +

3 comments on “Tom’s Tutorials For Excel: Showing how Excel’s FILTER function extracts different combinations of “and” and “or” criteria records within a single formula.”

1. sandeep says:

   June 7, 2025 at 6:26 pm

   Very useful FILTER tips, Tom.

   Reply
   • Tom Urtis says:

     June 7, 2025 at 6:36 pm

     Thanks, Sandeep!

     Reply
2. Josephbrats says:

   February 25, 2026 at 12:14 am

   Thanks, I’ve been looking for this for a long time

   _________________
   ack 1 win

   Reply