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