Learn how to filter a source list of data to show what is missing from a secondary list (i.e., by what is missing). Also, see a super-cool sort trick to sort a list of single-cell full names by last name without splitting the full names into separate columns.
File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_FilterMissing.zip
00:36 File Download Instructions
00:45 Defining the Problem
01:34 Counting Occurrences of Attendees
01:55 Intelligent Range Selection with Dot-Operators
02:51 Inverting the Test Results
03:35 Filtering by the Test Results
04:48 Avoiding "Helper Column" Calculations
05:54 Sort Full Name by Last Name
09:28 All-In-1 Using the LET Function
