Select the column header arrow. Hold down the Alt F11 keys in Excel and it opens the Microsoft Visual Basic for Applications window. Check the Excel Essentials Course.
In this filter basics tutor.
MATCH is configured backwards with lookup values coming from the data and criteria used for the lookup array. For example to extract only data where the group is red and score is greater than 80 you can use a formula like this. Select the column header arrow. The FILTER formula in Excel is available in Office 365 only.