Ask Your Question
0

[FEATURE REQUEST] Libre Office Calc - Remove Duplicates [closed]

asked 2013-10-16 21:26:16 +0100

dkarnows gravatar image

updated 2013-10-16 21:26:54 +0100

The one thing I still close Calc for and open Excel is when I need to remove duplicates. Excel has a single button, Calc has a convoluted tedious process like this. The use-case for removing duplicates is fairly common for me: Wanting to sum up a column grouped by labels. So:

  1. Copy a column of labels to another empty column
  2. Remove dupes on this new column
  3. Generate a SUMIF over a numerical column for each of the items in the de-duped column values matching on the original label column

In Excel this is very quick to do. In Calc is takes way too long due to the step 2.

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-12 01:54:57.901062

2 Answers

Sort by » oldest newest most voted
1

answered 2013-10-16 22:11:30 +0100

m.a.riosv gravatar image

updated 2013-10-16 22:12:43 +0100

Please take a look to this thread:
http://nabble.documentfoundation.org/Generate-Unique-List-from-Values-in-Column-tc4077250.html#a4077276
in the Mailing List, at least three ways to get what you want. And with the two first you can get the sum in one step, the better for me is the first using the Pivot Table, designed between other task for this.

edit flag offensive delete link more

Comments

Using filter doesn't actually removes duplicates. It just hide them. Need extra step to copy-paste the result to other rows below outside the filtered range.

Paijo gravatar imagePaijo ( 2013-10-17 04:29:15 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-10-16 21:26:16 +0100

Seen: 3,607 times

Last updated: Oct 16 '13