Ask Your Question

Calc: Extract unique values and add the numbers next to it [closed]

asked 2018-05-09 19:56:36 +0200

vulanala gravatar image

updated 2018-05-09 20:28:30 +0200

LibreTraining gravatar image

Gosh, I dont know how to describe this seemingly simple problem I have. An example is so much easier.

Say I have two columns :

Apple      5
Orange     3
Apple      1

Now I want to automatically create two columns where one is all the unique value in column A and the other is the aggregate of all the numbers that corresponds to that value. So for the table above it would create :

Apple  6
Orange 3

I found out how to extract the unique values here : but I don't know how to add the numbers next to them There are hundreds of items and potentially more incoming. So I'm wondering if Libre can automate the task

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by m.a.riosv
close date 2018-05-09 23:25:25.492632

1 Answer

Sort by » oldest newest most voted

answered 2018-05-09 20:21:57 +0200

vulanala gravatar image

Instead of using all kinds formulas, Libre Calc actually already have a powerful tools built in for these kinds of job. I finally tried Pivot Table (Data - Pivot Table - Create Table) and it solved everything in a matter of seconds.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-05-09 19:56:36 +0200

Seen: 45 times

Last updated: May 09 '18