We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How to auto delete rows with duplicate row data in Calc - Linux? [closed]

asked 2014-05-29 12:57:13 +0200

lanieb gravatar image

updated 2020-08-29 22:45:28 +0200

Alex Kemp gravatar image

I have a spreadsheet that contains a list of names. The names were listed several times and was entered into different rows.

For Instance, the name "Diego Garcia" was listed 6 times, and each appearing in a row. So Diego Garcia were listed in 6 rows.

What I would like to do is to automatically delete the duplicate name entry by deleting the whole row. I'am talking about 40k listed names here, all have duplicates.

You may have a look at the sample data I'm working on right now. See attached image.

image description

From the attached image, I'd like to do the following; Leave row 1292 Delete rows 1293 - 1304

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-29 22:45:12.207967


Problem Solved!

Thanks for Mahfiaz answer, It gave me an Idea. I got my problem solved by using Data -> Filter -> Standard Filter > Options > Tick the following; No duplicates Range contains column labels

Prior to doing the above steps, I've already highlighted the whole column of my spreadsheet that needs removal of duplicates, in my case is Column C. So from the standard filter window, Fieldname is set to column C, Conditions set to =, Value set to not empty. This video also helped.

lanieb gravatar imagelanieb ( 2014-05-29 16:32:51 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-05-29 13:34:40 +0200

mahfiaz gravatar image

See Data → Filter → Advanced Filter → More → Duplicate rows disabled

edit flag offensive delete link more


Actually there is no "More" Menu in my LibreOffice Calc version, probably it's the same with "Options" Menu?

The one with option select menus; No duplicates, Regular expression, Copy result to.

I don't know how to use that menu yet, I'll do a search.

lanieb gravatar imagelanieb ( 2014-05-29 16:03:55 +0200 )edit

Your answer served as an icebreaker. Thank.

lanieb gravatar imagelanieb ( 2014-05-29 16:25:50 +0200 )edit

"More" should be a button in the dialog which is in "Advanced filter" dialog. Its name might be "Advanced" as well, I use localized LibO. Sorry about that. But glad you got it going anyway.

mahfiaz gravatar imagemahfiaz ( 2014-05-29 16:42:29 +0200 )edit

answered 2016-02-11 08:27:03 +0200

Lion gravatar image


This could also help

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-05-29 12:57:13 +0200

Seen: 53,240 times

Last updated: Feb 11 '16