Based on a list

Summary

This video looks at how to filter based on a list of values

Tab in example file: Based on a list

To filter based on a list, we combine XMATCH and ISNUMBER to create an array of TRUE/FALSE values. This is used as the include argument inside FILTER.