Skip to content
Share
Explore

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
theDates
groupIndex
Button
duplicatesCount
13/09/2022
1
Remove Duplicate
11
11
09/09/2022
1
Remove Duplicate
11
11
01/09/2022
1
Remove Duplicate
11
11
27/08/2022
1
Remove Duplicate
11
11
23/08/2022
1
Remove Duplicate
11
11
18/08/2022
1
Remove Duplicate
11
11
18/08/2022
2
Remove Duplicate
11
11
11/08/2022
1
Remove Duplicate
11
11
03/08/2022
1
Remove Duplicate
11
11
23/07/2022
1
Remove Duplicate
11
11
20/07/2022
1
Remove Duplicate
11
11
16/07/2022
1
Remove Duplicate
11
11
15/07/2022
1
Remove Duplicate
11
11
13/07/2022
1
Remove Duplicate
11
11
12/07/2022
1
Remove Duplicate
11
11
08/07/2022
1
Remove Duplicate
11
11
01/07/2022
1
Remove Duplicate
11
11
28/06/2022
1
Remove Duplicate
11
11
28/06/2022
2
Remove Duplicate
11
11
16/06/2022
1
Remove Duplicate
11
11
10/06/2022
1
Remove Duplicate
11
11
10/06/2022
2
Remove Duplicate
11
11
04/06/2022
1
Remove Duplicate
11
11
31/05/2022
1
Remove Duplicate
11
11
26/05/2022
1
Remove Duplicate
11
11
21/05/2022
1
Remove Duplicate
11
11
18/05/2022
1
Remove Duplicate
11
11
13/05/2022
1
Remove Duplicate
11
11
11/05/2022
1
Remove Duplicate
11
11
29/04/2022
1
Remove Duplicate
11
11
23/04/2022
1
Remove Duplicate
11
11
16/04/2022
1
Remove Duplicate
11
11
08/04/2022
1
Remove Duplicate
11
11
06/04/2022
1
Remove Duplicate
11
11
01/04/2022
1
Remove Duplicate
11
11
24/03/2022
1
Remove Duplicate
11
11
19/03/2022
1
Remove Duplicate
11
11
15/03/2022
1
Remove Duplicate
11
11
11/03/2022
1
Remove Duplicate
11
11
05/03/2022
1
Remove Duplicate
11
11
26/02/2022
1
Remove Duplicate
11
11
23/02/2022
1
Remove Duplicate
11
11
12/02/2022
1
Remove Duplicate
11
11
10/02/2022
1
Remove Duplicate
11
11
08/02/2022
1
Remove Duplicate
11
11
29/01/2022
1
Remove Duplicate
11
11
20/01/2022
1
Remove Duplicate
11
11
11/01/2022
1
Remove Duplicate
11
11
01/01/2022
1
Remove Duplicate
11
11
17/09/2022
1
Remove Duplicate
11
11
06/10/2022
1
Remove Duplicate
11
11
04/10/2022
1
Remove Duplicate
11
11
01/10/2022
1
Remove Duplicate
11
11
30/09/2022
1
Remove Duplicate
11
11
22/09/2022
1
Remove Duplicate
11
11
21/09/2022
1
Remove Duplicate
11
11
05/10/2022
1
Remove Duplicate
11
11
29/09/2022
1
Remove Duplicate
11
11
28/09/2022
1
Remove Duplicate
11
11
27/09/2022
1
Remove Duplicate
11
11
24/09/2022
1
Remove Duplicate
11
11
23/09/2022
1
Remove Duplicate
11
11
20/09/2022
1
Remove Duplicate
11
11
20/09/2022
2
Remove Duplicate
11
11
16/09/2022
1
Remove Duplicate
11
11
15/09/2022
1
Remove Duplicate
11
11
14/09/2022
1
Remove Duplicate
11
11
10/09/2022
1
Remove Duplicate
11
11
08/09/2022
1
Remove Duplicate
11
11
07/09/2022
1
Remove Duplicate
11
11
06/09/2022
1
Remove Duplicate
11
11
03/09/2022
1
Remove Duplicate
11
11
02/09/2022
1
Remove Duplicate
11
11
31/08/2022
1
Remove Duplicate
11
11
30/08/2022
1
Remove Duplicate
11
11
26/08/2022
1
Remove Duplicate
11
11
25/08/2022
1
Remove Duplicate
11
11
25/08/2022
2
Remove Duplicate
11
11
24/08/2022
1
Remove Duplicate
11
11
20/08/2022
1
Remove Duplicate
11
11
19/08/2022
1
Remove Duplicate
11
11
13/08/2022
1
Remove Duplicate
11
11
13/08/2022
2
Remove Duplicate
11
11
12/08/2022
1
Remove Duplicate
11
11
10/08/2022
1
Remove Duplicate
11
11
09/08/2022
1
Remove Duplicate
11
11
06/08/2022
1
Remove Duplicate
11
11
05/08/2022
1
Remove Duplicate
11
11
04/08/2022
1
Remove Duplicate
11
11
02/08/2022
1
Remove Duplicate
11
11
30/07/2022
1
Remove Duplicate
11
11
29/07/2022
1
Remove Duplicate
11
11
28/07/2022
1
Remove Duplicate
11
11
27/07/2022
1
Remove Duplicate
11
11
26/07/2022
1
Remove Duplicate
11
11
21/07/2022
1
Remove Duplicate
11
11
19/07/2022
1
Remove Duplicate
11
11
14/07/2022
1
Remove Duplicate
11
11
09/07/2022
1
Remove Duplicate
11
11
07/07/2022
1
Remove Duplicate
11
11
06/07/2022
1
Remove Duplicate
11
11
05/07/2022
1
Remove Duplicate
11
11
05/07/2022
2
Remove Duplicate
11
11
02/07/2022
1
Remove Duplicate
11
11
30/06/2022
1
Remove Duplicate
11
11
29/06/2022
1
Remove Duplicate
11
11
25/06/2022
1
Remove Duplicate
11
11
24/06/2022
1
Remove Duplicate
11
11
23/06/2022
1
Remove Duplicate
11
11
22/06/2022
1
Remove Duplicate
11
11
21/06/2022
1
Remove Duplicate
11
11
18/06/2022
1
Remove Duplicate
11
11
17/06/2022
1
Remove Duplicate
11
11
15/06/2022
1
Remove Duplicate
11
11
14/06/2022
1
Remove Duplicate
11
11
11/06/2022
1
Remove Duplicate
11
11
09/06/2022
1
Remove Duplicate
11
11
08/06/2022
1
Remove Duplicate
11
11
03/06/2022
1
Remove Duplicate
11
11
02/06/2022
1
Remove Duplicate
11
11
01/06/2022
1
Remove Duplicate
11
11
28/05/2022
1
Remove Duplicate
11
11
25/05/2022
1
Remove Duplicate
11
11
24/05/2022
1
Remove Duplicate
11
11
20/05/2022
1
Remove Duplicate
11
11
19/05/2022
1
Remove Duplicate
11
11
19/05/2022
2
Remove Duplicate
11
11
17/05/2022
1
Remove Duplicate
11
11
14/05/2022
1
Remove Duplicate
11
11
12/05/2022
1
Remove Duplicate
11
11
10/05/2022
1
Remove Duplicate
11
11
07/05/2022
1
Remove Duplicate
11
11
06/05/2022
1
Remove Duplicate
11
11
05/05/2022
1
Remove Duplicate
11
11
04/05/2022
1
Remove Duplicate
11
11
03/05/2022
1
Remove Duplicate
11
11
30/04/2022
1
Remove Duplicate
11
11
28/04/2022
1
Remove Duplicate
11
11
27/04/2022
1
Remove Duplicate
11
11
26/04/2022
1
Remove Duplicate
11
11
22/04/2022
1
Remove Duplicate
11
11
21/04/2022
1
Remove Duplicate
11
11
20/04/2022
1
Remove Duplicate
11
11
15/04/2022
1
Remove Duplicate
11
11
14/04/2022
1
Remove Duplicate
11
11
13/04/2022
1
Remove Duplicate
11
11
12/04/2022
1
Remove Duplicate
11
11
09/04/2022
1
Remove Duplicate
11
11
07/04/2022
1
Remove Duplicate
11
11
07/04/2022
2
Remove Duplicate
11
11
05/04/2022
1
Remove Duplicate
11
11
02/04/2022
1
Remove Duplicate
11
11
31/03/2022
1
Remove Duplicate
11
11
30/03/2022
1
Remove Duplicate
11
11
29/03/2022
1
Remove Duplicate
11
11
26/03/2022
1
Remove Duplicate
11
11
25/03/2022
1
Remove Duplicate
11
11
23/03/2022
1
Remove Duplicate
11
11
22/03/2022
1
Remove Duplicate
11
11
18/03/2022
1
Remove Duplicate
11
11
17/03/2022
1
Remove Duplicate
11
11
16/03/2022
1
Remove Duplicate
11
11
12/03/2022
1
Remove Duplicate
11
11
10/03/2022
1
Remove Duplicate
11
11
09/03/2022
1
Remove Duplicate
11
11
08/03/2022
1
Remove Duplicate
11
11
04/03/2022
1
Remove Duplicate
11
11
03/03/2022
1
Remove Duplicate
11
11
02/03/2022
1
Remove Duplicate
11
11
01/03/2022
1
Remove Duplicate
11
11
25/02/2022
1
Remove Duplicate
11
11
24/02/2022
1
Remove Duplicate
11
11
22/02/2022
1
Remove Duplicate
11
11
19/02/2022
1
Remove Duplicate
11
11
18/02/2022
1
Remove Duplicate
11
11
17/02/2022
1
Remove Duplicate
11
11
16/02/2022
1
Remove Duplicate
11
11
15/02/2022
1
Remove Duplicate
11
11
11/02/2022
1
Remove Duplicate
11
11
09/02/2022
1
Remove Duplicate
11
11
05/02/2022
1
Remove Duplicate
11
11
04/02/2022
1
Remove Duplicate
11
11
03/02/2022
1
Remove Duplicate
11
11
02/02/2022
1
Remove Duplicate
11
11
01/02/2022
1
Remove Duplicate
11
11
28/01/2022
1
Remove Duplicate
11
11
27/01/2022
1
Remove Duplicate
11
11
26/01/2022
1
Remove Duplicate
11
11
26/01/2022
2
Remove Duplicate
11
11
25/01/2022
1
Remove Duplicate
11
11
22/01/2022
1
Remove Duplicate
11
11
21/01/2022
1
Remove Duplicate
11
11
19/01/2022
1
Remove Duplicate
11
11
18/01/2022
1
Remove Duplicate
11
11
15/01/2022
1
Remove Duplicate
11
11
14/01/2022
1
Remove Duplicate
11
11
13/01/2022
1
Remove Duplicate
11
11
12/01/2022
1
Remove Duplicate
11
11
08/01/2022
1
Remove Duplicate
11
11
07/01/2022
1
Remove Duplicate
11
11
07/01/2022
2
Remove Duplicate
11
11
06/01/2022
1
Remove Duplicate
11
11
05/01/2022
1
Remove Duplicate
11
11
04/01/2022
1
Remove Duplicate
11
11
There are no rows in this table
⁠

My blog about it:
⁠
Loading
medium.com
⁠
⁠
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.