Excel’s Filter function (365 only) makes it super-easy to create a copy of a list but only display specific items.
It’s the 21st century version of Data > Advanced Filter > Copy to Another Location, which, if you’ve used it, you’ll know all too well the pain points of updating the output range when the input range or criteria range changes.
So if you’re an Excel 365 subscriber looking to generate dynamic filtered ranges, forget Advanced Filter. Give the FILTER function a try. You’ll wonder how you’ve lived without it for so long!
Links to the video and individual sections below:
The FILTER Function: Single Criteria
The FILTER Function: Multiple Criteria: Logical OR