Oct 12, 2022 6:00 AM

FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL?

External YouTube Channel

Learn how to filter records based on a list of values using Excel worksheet formula..

Topics:

  1. (00:00) Introduction
  2. (00:26) Filter records based on a list of values using FILTER, XMATCH and ISNUMBER functions.
  3. (02:22) VSTACK function to Filter records based on one or more lists from any were on worksheet.
  4. (03:19) TOCOL function to Filter records based on one or more lists that are listed sequentially.
  5. (04:09) Summary, Closing, Video Links

Download the Sheet

https://excelisfun.net/files/EMT1799....