Excel FILTER Function

If you are struggling with VLOOKUP or INDEX MATCH because they are either too complicated or fail to display all matching entries at once, the Excel FILTER function offers a…