Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

In this article, I’ll show you how to include AND and OR operations in Excel’s FILTER () function. In several spots, you’ll read “AND and OR,” which is grammatically awkward.

Example 2: For text-based filtering, such as extracting rows where the product name contains specific keywords, you can combine the FILTER function with text functions like SEARCH or FIND.

From the image above, you can see we have chosen to select the B4:D15 range. Please navigate to the Data tab, then click the Filter option twice. You can find Filter via the Sort & Filter group.