Completed
min) Array formula to sort (ascending) records based on numeric column.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas
Automatically move to the next video in the Classroom when playback concludes
- 1 min) Extract Unique List with PivotTable.
- 2 min) Extract Unique List with Advanced Filter.
- 3 min) Extract Unique List with Formula: INDEX and SMALL functions.
- 4 min) Extract Unique List with Formula: Helper Column.
- 5 min) Extract Unique Records (more than one column) with helper column formula.
- 6 min) Sort numbers with formula.
- 7 min) Helper column formula to sort (ascending) records based on numeric column.
- 8 min) Array formula to sort (ascending) records based on numeric column.
- 9 min) Extract top 3 score and name associated with score (including ties).
- 10 min) Helper column formula to sort (ascending) records based on text column.
- 11 min) Extract unique list of words and sort with formula when there are no empty cells.
- 12 min) Extract unique list of mixed data and sort with formula, empty cells okay.
