Level 2Clean InputsPractice, 3 min
UNIQUE: one row per person
The task
Eight webinar signups, but some people registered twice, once with stray spaces or capitals. In D2, list each email once: clean the column with
TRIM and LOWER, then wrap it in UNIQUE.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Signed up | Unique emails | ||
| 2 | Reg 1 | [email protected] | ||
| 3 | Reg 2 | [email protected] | ||
| 4 | Reg 3 | [email protected] | ||
| 5 | Reg 4 | [email protected] | ||
| 6 | Reg 5 | [email protected] | ||
| 7 | Reg 6 | [email protected] | ||
| 8 | Reg 7 | [email protected] | ||
| 9 | Reg 8 | [email protected] |