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

[lanieb]

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.

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

[lanieb]

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.

[mahfiaz]

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

[lanieb]

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]

Your answer served as an icebreaker. Thank.

[mahfiaz]

“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.

[Lion]

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

This could also help