I have sheet libreoffice calc with thousands of unique values in one column.
From this sheet each time must removed a few hundred.
that’s what I do :
1)Add the records that I want to remove at the end of the column.
2) formats the duplicate records with a different color
and I want :
1)with a filter i want to only see the duplicate records so i can copy or delete this records
2)and I get the unique registration and copy them to a different sheet
I would like to thank anyone give me his time and the help me