Count distinct values and show the list
Your goal: See which customer names are distinct, exclude blank rows, and count the resulting list.
Full task requirements
Create the distinct list in B2:B9 and its count in E2. Ignore empty cells, keep the first spelling, and treat letter case as equivalent.
Customer namesKeep the first occurrence of each value
- Rule
- First occurrence; ignore case and blanks
| # | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 |
Step 1 of 1
Keep the first occurrence of each value
How the Excel rule works
Ignore empty cells and compare text without letter case. Select the first source occurrence for each distinct value, preserving its spelling. Numbers and text stay distinct.
Inspect selected records
No records selected yet.