Ask Your Question

How do add up duplicate accords

asked 2017-10-29 13:35:02 +0200

Kool gravatar image

Hey hey,

Not to sure if this is the right place since I am new here but given it a shot... I have a how to problem with Calc. I would like to add up participants if the town they come from is the same and show them as a single reccord.

edit retag flag offensive close merge delete


For me it's unclear what you mean by "record". That's a technical term for databasing, but I cannot see how it should apply here. In a similar way the term "add up" is unclear. @JohnSUN obviously interpreted it as a kind of concatenation, but you second post coming as an answer (not being one exactly) seems to tell me he didn't guess right. Please note that the way JohnSUN used TEXTJOIN only works well with V5.2.3 or higher of LibO.

Lupp gravatar imageLupp ( 2017-10-29 16:55:16 +0200 )edit

I will now see for the "karma" you need to make attachments. Pleas do so by editing your question and using the "paperclip-tool" then. When editing posts, please make clear what was changed/appended.

You may also delete your "answer" after editing your question, as it doesn't actually answer anything.

Lupp gravatar imageLupp ( 2017-10-29 16:56:57 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-10-29 16:02:13 +0200

JohnSUN gravatar image

You can do this very simple with formula like as

{=TEXTJOIN(", ";1;IF($A$2:$A$100=E2;$B$2:$B$100;""))}

See example

edit flag offensive delete link more

answered 2017-10-29 16:29:04 +0200

Kool gravatar image

Thanks for your time and trouble Somehow my example did not upload... I Will try again hopefully it becomes a little bit clearer

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-29 13:35:02 +0200

Seen: 20 times

Last updated: Oct 29 '17