Level 3Formulas That SpillPractice, 2 min
COUNTUNIQUE customers
The task
Ten orders, but how many different customers? In E2, count them with
COUNTUNIQUE.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Customer | Amount | Customers | |
| 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 |