1
00:00:00,080 --> 00:00:04,361
The fictional source has eight rows, but two are blank and

2
00:00:04,361 --> 00:00:05,918
two customer names repeat.

3
00:00:05,918 --> 00:00:10,199
A simple row count would badly overstate the number of customers.

4
00:00:10,199 --> 00:00:14,091
We will filter blanks, remove repeated names without deleting source

5
00:00:14,091 --> 00:00:16,815
records, and verify exactly four distinct names.

6
00:00:17,415 --> 00:00:18,953
Read A2 through A9.

7
00:00:18,953 --> 00:00:23,182
North Pier and Cedar Lab each occur twice; Harbor Co and

8
00:00:23,182 --> 00:00:26,257
Ridge Works occur once; two rows are blank.

9
00:00:26,257 --> 00:00:31,254
That makes eight source rows, six filled entries, and four distinct nonblank names.

10
00:00:31,254 --> 00:00:33,561
These three counts answer different questions.

11
00:00:34,161 --> 00:00:38,326
Enter FILTER on A2 through A9 with a not-blank condition.

12
00:00:38,326 --> 00:00:40,220
That leaves six filled names.

13
00:00:40,220 --> 00:00:45,142
Apply UNIQUE to that result, then ROWS to count the four remaining entries.

14
00:00:45,142 --> 00:00:48,929
Filtering first matters because a blank could otherwise enter the

15
00:00:48,929 --> 00:00:51,580
distinct-value list as an extra category.

16
00:00:52,180 --> 00:00:58,025
For an extra audit, put =UNIQUE(FILTER(A2:A9,A2:A9<>"")) in a clear area

17
00:00:58,025 --> 00:00:59,973
and read its spilled names.

18
00:00:59,973 --> 00:01:04,649
They should be North Pier, Cedar Lab, Harbor Co, and Ridge Works.

19
00:01:04,649 --> 00:01:08,935
The list is more informative than a lone number because it

20
00:01:08,935 --> 00:01:10,493
exposes unexpected spelling variants.

21
00:01:11,093 --> 00:01:15,805
The ordinary UNIQUE list contains a name even when it appears several times.

22
00:01:15,805 --> 00:01:20,154
That is why North Pier and Cedar Lab remain in our four.

23
00:01:20,154 --> 00:01:24,141
A setting that returns only values appearing exactly once would answer

24
00:01:24,141 --> 00:01:28,490
a different question and would leave just Harbor Co and Ridge Works.

25
00:01:29,090 --> 00:01:33,672
If the output shows five names, inspect a blank or spelling difference.

26
00:01:33,672 --> 00:01:37,873
North Pier with an extra trailing space can look identical on

27
00:01:37,873 --> 00:01:39,400
screen but count separately.

28
00:01:39,400 --> 00:01:43,601
Clean the business identity field only with an explicit rule; this

29
00:01:43,601 --> 00:01:48,183
lesson preserves the fictional source and makes no claim about fuzzy matching.