Ask Your Question
0

How to auto delete rows with duplicate row data in Calc 4.2.3.3 - Linux?

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

lanieb gravatar image

updated 2015-09-05 22:50:40 +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 close merge delete

Comments

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
1

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

Comments

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
0

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

Lion gravatar image

=COUNTIF($F$2:$F$58;F2)

This could also help

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 45,374 times

Last updated: Feb 11 '16