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.
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.
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.
You can do this very simple with formula like as
{=TEXTJOIN(", ";1;IF($A$2:$A$100=E2;$B$2:$B$100;""))}
See example
Thanks for your time and trouble
Somehow my example did not upload… I Will try again hopefully it becomes a little bit clearer