Share
Explore

icon picker
Unique Records

Using a group index and a canvas button
Christiaan Huizer
I am aware we have the function Duplicates() at our disposal. Nevertheless, this template makes use of what I call a Group Index.
The logic can be applied in various ways. For demonstration purposes I assumed it was easy to only set the buttons active that are on a row with a duplicate.
A duplicate is a row that is counted more than once, thus contains a number higher than 1 (2 → n)
A
groupIndex
⁠
is created by filtering on the row itself while asking for the relative position in the table.

→ Click the button and you see it happen.

⁠
remove duplicates
⁠
⁠

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

My blog about it:
⁠
This link can't be embedded.
⁠
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.