Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_13

13. FILTER Function: The Game Changer

Alan Murray¹  

(1)

IPSWICH, UK

 

When the dynamic array formulas were covered in Chapter 10, the FILTER function was omitted. FILTER was introduced in Excel at the same time as the other dynamic array formulas – SORT, UNIQUE, SEQUENCE, etc. This function will make you wonder, how did I work before the FILTER function? And for this reason, it has its own chapter.

A common question I receive in my training sessions and comments on my YouTube channel is how to write a lookup formula to return all matching results. Functions such as VLOOKUP, the INDEX-MATCH ...