Unique
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Data (notice duplicates)Exact Duplicates removedFormula
2
TheTheunique(A2:A6)
3
CatCat
4
ininNote: See how only "Cats" is removed?
5
thetheThis is because unique() is case sensitive
6
Cat
7
8
DataAll duplicates removedFormula
9
Thethe
arrayformula(UNIQUE(trim(clean(lower(A9:A13)))))
10
Catcat
11
inin
Note: All of the duplicates are removed, don't get scared here!
12
the
The reason why I've included trim(), clean() and lower() is
13
Cat
to ensure that I removed any whitespaces and lowercase (lower()) all values
14
then I can apply arrayformula() to specify the entire range of cells
15
and finally de-duplicate using unique()
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu