How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel Your email has ... keeping in mind that you must be working with a Table object ...

When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure referencing at work instead of the actual range (array) references that I use.

So how does the FILTER function work? Let’s walk through some examples. To follow along, download this Excel workbook. A video demonstration also is available at the bottom of this article. Note that ...