Level 3Formulas That SpillPractice, 2 min
A sorted list of customers
The task
In E2, list each customer once, in A to Z order, with
UNIQUE inside SORT.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Customer | Amount | Customer list | |
| 2 | 5001 | Northwind | $1,200 | ||
| 3 | 5002 | Cobalt Labs | $640 | ||
| 4 | 5003 | Northwind | $980 | ||
| 5 | 5004 | Brightline | $2,150 | ||
| 6 | 5005 | Harbor & Co | $410 | ||
| 7 | 5006 | Cobalt Labs | $760 | ||
| 8 | 5007 | Northwind | $1,330 | ||
| 9 | 5008 | Fieldstone | $2,900 | ||
| 10 | 5009 | Brightline | $515 | ||
| 11 | 5010 | Quillworks | $870 |