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

Ask Your Question
1

how to remove entire row based on duplicates from single column in libre calc? [closed]

asked 2013-12-06 04:23:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi! I have a table of 10 - 15 columns with 7000 rows containing a lot of data I have one column that contains a lot of duplicates, call it column N and I want to delete the entire row where the data is duplicate in row N and also i want to keep one of the rows, and only remove the duplicates.

I can highlight the duplicates and filter them but this takes way too long...

I cant use the "remove duplicates" button either because this only removes "duplicate rows", not rows that have duplicates in a particular column.

Can somebody help me.

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 2021-05-31 23:01:25.160976

Comments

OP: @rea ..

manj_k gravatar imagemanj_k ( 2014-05-20 21:19:17 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2013-12-09 03:24:23 +0200

m.a.riosv gravatar image

Adding a extra column with a formula like:
=COUNTIF($X$1:$X$7000;$X1)
copy down up the last row with data.
This formula resuls in value > 1 for the duplicated rows.
Filtering by this column for a non 1 value, shows all duplicated rows.

edit flag offensive delete link more

Comments

it doesn't work... but thanks anyway

rea gravatar imagerea ( 2014-01-07 03:29:09 +0200 )edit
1

Works perfectly, just need to make sure the cell references are correct.

rautamiekka gravatar imagerautamiekka ( 2015-04-10 17:49:42 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-12-06 04:23:27 +0200

Seen: 7,452 times

Last updated: Dec 09 '13