DYNAMIC ARRAYS · ORIGINAL EXERCISE
Gather the regions
Return a vertical list of distinct region names from B2:B9, preserving first appearance. Use UNIQUE.
This quest practices UNIQUE using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Order | Region | Product | Units | Revenue | Cost |
|---|---|---|---|---|---|
| O-101 | North | Keyboard | 12 | 720 | 420 |
| O-102 | South | Mouse | 18 | 450 | 198 |
| O-103 | North | Monitor | 5 | 1250 | 900 |
| O-104 | West | Keyboard | 8 | 480 | 280 |
| O-105 | South | Monitor | 4 | 1000 | 720 |
| O-106 | North | Mouse | 20 | 500 | 220 |
| O-107 | West | Monitor | 6 | 1500 | 1080 |
| O-108 | East | Dock | 10 | 600 | 350 |
Hints to get you started
- A dynamic array returns several cells from one formula.
- UNIQUE keeps the first occurrence of each value.
- Pass B2:B9 as its array.
Show the worked solution
=UNIQUE(B2:B9)UNIQUE creates a live list. Cellcraft previews its result as a table; in modern Excel, the values spill into neighboring cells.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →