Members lesson 17
UNIQUE
Return distinct values, distinct row pairs, and entries that appear once.
What you will practice
- List distinct values with UNIQUE
- Compare complete rows across two columns
- Return entries that appear exactly once
Lesson preview
Starting tableTeam coverage
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Department | Shift | Departments | Distinct pairs | ||
| 2 | Operations | Morning | ||||
| 3 | Sales | Evening | ||||
| 4 | Operations | Morning | ||||
| 5 | Support | Morning | ||||
| 6 | Sales | Morning | ||||
| 7 | Finance | Evening | Appears once | |||
| 8 | Pairs appearing once |