I would like to delete duplicate entries in Calc and I can not find the command for this. Please advise.
Menu Data -> Filter -> Standard Filter... check Options No duplications and Copy results to: … enter a suitable location’s top left cell, for example on a new sheet created beforehand.
It is working +/- OK but it seems that it struggles with big volumes 50.000+ rows !
Mentionning that the data should be selected first would be good.
What I needed to do was a bit more painful :
Copy the data to another empty sheet and then treating them with shell scripts was the quickest !
that works for ‘complete’ duplicate records (all columns identical), to remove acc. duplicates in selected columns don’t use ‘copy output to’ but filter ‘in place’ and copy results afterwards if neccessary,
be aware that prior to copy to another place calc only filters (hides) the records while ex$el with it’s functionality ‘remove duplicates’ - i think that’s was the OP had been looking for - removes them,
be aware that calc works on whole rows, while ex$el restricts it’s removal to the addressed / selected range,