Extract values associaed with the same person in one cell comma separated

[Smirni]

Hello experts,

I just can't figure out how to get it in.
I have a list of names in column A
And results in column B

Now I would like in D1 all results from the name I enter in C1 from column A.

	A	B	C	D
1	Person 1	12	Person 1	12, 1, 5
1	Person 2	2
3	Person 3	8
4	Person 1	1
5	Person 1	5

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

As you are new I changed it for you.Please read forum rules

[Vraag en antwoord]

With an array formula in D1

Please Login or Register  to view this content.

[MarvinP]

Hi Smirni and welcome to the forum,

This looks like the TextJoin() command should do what you want. See the attached to see your example and my answer. I think there might be other methods tool

TextJoin If Match Ignore Blanks.xlsx

I just checked my formula of:

Please Login or Register  to view this content.

and it doesn't need to be an array or CSE formula.

[XOR LX]

I just checked my formula of:

Please Login or Register  to view this content.

and it doesn't need to be an array or CSE formula.

Then you didn't check well enough! It does indeed require CSE.

Regards

[Fluff13]

It does indeed require CSE.

Not if you've got dynamic arrays
However the OP is on 2016 which doesn't have TextJoin