Ask Your Question
0

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

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

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 question is not relevant or outdated by Alex Kemp
close date 2015-11-16 14:22:18.767345

Comments

OP: @rea ..

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

1 Answer

Sort by » oldest newest most voted
1

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

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 +0100 )edit

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

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

Question Tools

1 follower

Stats

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

Seen: 5,969 times

Last updated: Dec 09 '13