[FEATURE REQUEST] Libre Office Calc - Remove Duplicates

[dkarnows]

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.

[mariosv]

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.

[Paijo]

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.