Blog Archives

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

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

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

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , ,

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

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

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

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Explaining Excel’s FILTER function to extract multiple “and” criteria records, by using the asterisk * operator.

Keywords: Excel 365; FILTER; if_empty; AND; Asterisk

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

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Filtering for the literal question mark “?”, asterisk “*”, and tilde “~” wildcard characters.

Filtering for the literal question mark “?”, asterisk “*”, and tilde “~” wildcard characters, by using a preceding tilde.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,