Task 1 of 2
Highlight the duplicate emails in A2:A9.
Lesson theory
- Duplicate Values is the quickest way to find repeats: the same email, ID or part number;
- Text that Contains highlights every cell where a word appears. Letter case does not matter.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page