Task 1 of 6
In E2, list the courses without duplicates, in alphabetical order, with a single formula.
Lesson theory
A training center takes applications for courses with an entrance test. Let's build a summary by course and a ranking of applicants with formulas that spill to as many rows as needed.
Tip: write the formula in the first cell only, and refer to the whole result with #: E2#.
If there is data below or to the right, you get #SPILL!.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.