Share
Explore

How to count unique items in a cell
Solution below defined by the great J
The buttons is the longer way, but for many users maybe easier to understand. You distribute the values over rows in second table. In that table you count the unique values based on a familiair Filter based formula and a good to read format formula.

Format("We find {1} {2} times",thisRow.Name,thisRow.TheCount)

Solution via a pack in the community :
base
0

HLPR
0
Name
TheCount
TheTexts
1
1
1
We find 1 1 times
2
2
1
We find 2 1 times
3
3
4
We find 3 4 times
4
3
4
We find 3 4 times
5
3
4
We find 3 4 times
6
3
4
We find 3 4 times
7
4
6
We find 4 6 times
8
4
6
We find 4 6 times
9
4
6
We find 4 6 times
10
4
6
We find 4 6 times
11
4
6
We find 4 6 times
12
4
6
We find 4 6 times
13
5
3
We find 5 3 times
14
5
3
We find 5 3 times
15
5
3
We find 5 3 times
16
6
1
We find 6 1 times
17
7
2
We find 7 2 times
18
7
2
We find 7 2 times
19
8
4
We find 8 4 times
20
8
4
We find 8 4 times
21
8
4
We find 8 4 times
22
8
4
We find 8 4 times
23
9
1
We find 9 1 times
24
10
2
We find 10 2 times
25
10
2
We find 10 2 times
26
11
1
We find 11 1 times
27
12
5
We find 12 5 times
28
12
5
We find 12 5 times
29
12
5
We find 12 5 times
30
12
5
We find 12 5 times
31
12
5
We find 12 5 times
32
13
5
We find 13 5 times
33
13
5
We find 13 5 times
34
13
5
We find 13 5 times
35
13
5
We find 13 5 times
36
13
5
We find 13 5 times
37
14
2
We find 14 2 times
38
14
2
We find 14 2 times
39
15
2
We find 15 2 times
40
15
2
We find 15 2 times
41
16
6
We find 16 6 times
42
16
6
We find 16 6 times
43
16
6
We find 16 6 times
44
16
6
We find 16 6 times
45
16
6
We find 16 6 times
46
16
6
We find 16 6 times
47
17
1
We find 17 1 times
48
18
4
We find 18 4 times
49
18
4
We find 18 4 times
50
18
4
We find 18 4 times
51
18
4
We find 18 4 times
52
20
4
We find 20 4 times
53
20
4
We find 20 4 times
54
20
4
We find 20 4 times
55
20
4
We find 20 4 times
56
21
5
We find 21 5 times
57
21
5
We find 21 5 times
58
21
5
We find 21 5 times
59
21
5
We find 21 5 times
60
21
5
We find 21 5 times
61
23
2
We find 23 2 times
62
23
2
We find 23 2 times
63
24
5
We find 24 5 times
64
24
5
We find 24 5 times
65
24
5
We find 24 5 times
66
24
5
We find 24 5 times
67
24
5
We find 24 5 times
68
25
5
We find 25 5 times
69
25
5
We find 25 5 times
70
25
5
We find 25 5 times
71
25
5
We find 25 5 times
72
25
5
We find 25 5 times
73
26
3
We find 26 3 times
74
26
3
We find 26 3 times
75
26
3
We find 26 3 times
76
27
2
We find 27 2 times
77
27
2
We find 27 2 times
78
28
2
We find 28 2 times
79
28
2
We find 28 2 times
80
29
4
We find 29 4 times
81
29
4
We find 29 4 times
82
29
4
We find 29 4 times
83
29
4
We find 29 4 times
84
30
1
We find 30 1 times
85
31
2
We find 31 2 times
86
31
2
We find 31 2 times
87
32
5
We find 32 5 times
88
32
5
We find 32 5 times
89
32
5
We find 32 5 times
90
32
5
We find 32 5 times
91
32
5
We find 32 5 times
92
33
2
We find 33 2 times
93
33
2
We find 33 2 times
94
34
5
We find 34 5 times
95
34
5
We find 34 5 times
96
34
5
We find 34 5 times
97
34
5
We find 34 5 times
98
34
5
We find 34 5 times
99
35
1
We find 35 1 times
100
36
1
We find 36 1 times
101
37
2
We find 37 2 times
102
37
2
We find 37 2 times
103
38
5
We find 38 5 times
104
38
5
We find 38 5 times
105
38
5
We find 38 5 times
106
38
5
We find 38 5 times
107
38
5
We find 38 5 times
108
39
5
We find 39 5 times
109
39
5
We find 39 5 times
110
39
5
We find 39 5 times
111
39
5
We find 39 5 times
112
39
5
We find 39 5 times
113
40
2
We find 40 2 times
114
40
2
We find 40 2 times
115
41
7
We find 41 7 times
116
41
7
We find 41 7 times
117
41
7
We find 41 7 times
118
41
7
We find 41 7 times
119
41
7
We find 41 7 times
120
41
7
We find 41 7 times
121
41
7
We find 41 7 times
122
42
1
We find 42 1 times
123
43
3
We find 43 3 times
124
43
3
We find 43 3 times
125
43
3
We find 43 3 times
126
44
4
We find 44 4 times
127
44
4
We find 44 4 times
128
44
4
We find 44 4 times
129
44
4
We find 44 4 times
130
45
6
We find 45 6 times
131
45
6
We find 45 6 times
132
45
6
We find 45 6 times
133
45
6
We find 45 6 times
134
45
6
We find 45 6 times
135
45
6
We find 45 6 times
136
46
4
We find 46 4 times
137
46
4
We find 46 4 times
138
46
4
We find 46 4 times
139
46
4
We find 46 4 times
140
47
3
We find 47 3 times
141
47
3
We find 47 3 times
142
47
3
We find 47 3 times
143
48
4
We find 48 4 times
144
48
4
We find 48 4 times
145
48
4
We find 48 4 times
146
48
4
We find 48 4 times
147
49
3
We find 49 3 times
148
49
3
We find 49 3 times
149
49
3
We find 49 3 times
150
51
2
We find 51 2 times
151
51
2
We find 51 2 times
152
52
5
We find 52 5 times
153
52
5
We find 52 5 times
154
52
5
We find 52 5 times
155
52
5
We find 52 5 times
156
52
5
We find 52 5 times
157
53
3
We find 53 3 times
158
53
3
We find 53 3 times
159
53
3
We find 53 3 times
160
54
3
We find 54 3 times
161
54
3
We find 54 3 times
162
54
3
We find 54 3 times
163
55
4
We find 55 4 times
164
55
4
We find 55 4 times
165
55
4
We find 55 4 times
166
55
4
We find 55 4 times
167
56
2
We find 56 2 times
168
56
2
We find 56 2 times
169
57
3
We find 57 3 times
170
57
3
We find 57 3 times
171
57
3
We find 57 3 times
172
58
4
We find 58 4 times
173
58
4
We find 58 4 times
174
58
4
We find 58 4 times
175
58
4
We find 58 4 times
176
59
1
We find 59 1 times
177
60
1
We find 60 1 times
178
61
3
We find 61 3 times
179
61
3
We find 61 3 times
180
61
3
We find 61 3 times
181
62
6
We find 62 6 times
182
62
6
We find 62 6 times
183
62
6
We find 62 6 times
184
62
6
We find 62 6 times
185
62
6
We find 62 6 times
186
62
6
We find 62 6 times
187
63
3
We find 63 3 times
188
63
3
We find 63 3 times
189
63
3
We find 63 3 times
190
64
5
We find 64 5 times
191
64
5
We find 64 5 times
192
64
5
We find 64 5 times
193
64
5
We find 64 5 times
194
64
5
We find 64 5 times
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP