The FILTER function was introduced five years ago as part of the Excel Dynamic Arrays rollout. The function has all the filtering power of the venerable ... as shown in the screenshot below. Let’s do ...