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 ...