No UNIQUE? No problem. Get a Dynamically Updating Unique List with Multiple Conditions in Excel

In this video, we use a combination of formulae to generate a dynamically-updated unique list of items in a spreadsheet (with multiple conditions). Even when repeated in a dataset, we get (automatically):
1. A unique list of athletes
2. Unique lists of athletes per their team assignments
3. A unique list of athletes per their team assignments and peak speed values