Monday, January 18, 2021

Perform a Lookup with the FILTER Function

One of the new Dynamic Array functions in Microsoft or Office 365 is the FILTER function and this can let you perform a lookup on a table of data. Generally when we think of filtering data it's already in a table and we're using the drop downs to filter based on some criteria. With the newer FILTER function, we can separate the source table and the output table in different parts of the worksheet tab or in separate worksheet tabs. This can even be used in scenarios where we'd want to make a dashboard to separate this. This video will cover some different examples of how FILTER can be used. Common usage (0:56) Multiple criteria (5:20) Find duplicate data (9:55) Output few adjacent columns (11:47) Output few non-adjacent columns (12:35)

No comments:

Post a Comment