Ask Your Question

Delete Duplicates in Calc [closed]

asked 2015-07-23 17:26:35 +0100

beloved_rose gravatar image

I would like to delete duplicate entries in Calc and I can not find the command for this. Please advise.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-23 08:21:29.142260

1 Answer

Sort by » oldest newest most voted

answered 2015-07-23 17:39:59 +0100

erAck gravatar image

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.

edit flag offensive delete link more


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 !

tls gravatar imagetls ( 2020-06-30 16:27:54 +0100 )edit

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,

newbie-02 gravatar imagenewbie-02 ( 2020-08-30 17:14:31 +0100 )edit

Question Tools



Asked: 2015-07-23 17:26:35 +0100

Seen: 114,174 times

Last updated: Jul 23 '15