Need MD wise all RSE name with commas

[Pankaj jaswani]

Hi,

I have shared a file containing a table data where you find RSE name according to their MD name. I want MD wise RSE name in a cell with commas. Please help me with this.

[Pepe Le Mokko]

Please enlighten me what does MD mean? what does RSE mean? Not everybody understands your technical jargon or initialisms...

[Pankaj jaswani]

MD means (Market Distributor -Column Header) and RSE means (Retail Sales Executive-Column Header).

If you see my attachment you will understand what I want.

[Pepe Le Mokko]

Be aware that members usually select the threads they will answer to by the title.
You cannot expect members to open attached sheets to understand what you mean, but they expect you to give them as much as possible easily accessible info so they do not waste their time.

[Fluff13]

How about
=TEXTJOIN(", ",,IF(Data!$D$8:$D$300=A2,Data!$A$8:$A$300,""))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[Pankaj jaswani]

@Pepe Le Mokko, First of all, I would like to inform you that I do not expect anyone to open the attached sheets to understand what I mean, I always define my problem as much I can. And my title is very clear. That thing is different that you did not understand this post of mine.

[Pankaj jaswani]

=TEXTJOIN(", ",,IF(Data!$D$8:$D$300=A2,Data!$A$8:$A$300,""))

@Fluff13 Thanks for reverting, but your formula is not working for me.

[Fluff13]

In what way?

[Pankaj jaswani]

In what way?

Data row starting from 2nd row and your range is starting from the 8th row. And after changing it your formula result showing the whole name in one cell I want RSE according to MD names as different MD have different RSEs.

[MarvinP]

Hi Pankaj,

I know that you want comma separated names but a Pivot Table (with slicer?) might be more useful when working with this data. See the attached for another way to access your data. If you click the "+" sign in the pivot it will expand to show all people under. Or use the slicer tool.
Company then Name by Pivot with Slicer.xlsx

[Fluff13]

I want RSE according to MD names

That is exactly what my idea does. It displays all RSE names for a particular MD.
If that is not what you want, then you will need to offer a better explanation. Or better yet, supply a workbook with the expected outcome.

[Pankaj jaswani]

@MarvinP, Bro thanks for reverting. But I want comma-separated names and I do not want to make it big process as I don't want it to count. I want to show all these names according to their MD.

[Pankaj jaswani]

That is exactly what my idea does. It displays all RSE names for a particular MD.
If that is not what you want, then you will need to offer a better explanation. Or better yet, supply a workbook with the expected outcome.

Okay. Please see this link http://www.filedropper.com/requiredf...xtjoinformulaf

In green cell the expected result.

[Fluff13]

Please upload the file to this site.

[alansidman]

Okay. Please see this link http://www.filedropper.com/requiredf...xtjoinformulaf

Many of our members are reluctant to open third party files for fear of virus infections or the requirement to join that web site. We urge you to read the yellow banner at the top of this page and upload a file directly to this site.

[Pankaj jaswani]

Please upload the file to this site.

Okay. please find.

[XOR LX]

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Looks like another case of an OP not following instructions re array formulas...

Regards

[Pankaj jaswani]

@XOR LX & Fluff13. Thanks to both of you. Now, it's working.

[Pankaj jaswani]

Many of our members are reluctant to open third party files for fear of virus infections or the requirement to join that web site. We urge you to read the yellow banner at the top of this page and upload a file directly to this site.

@alansidman Okay. Next time, I will follow the same.

[Fluff13]

You're welcome & thanks for the feedback

[AliGW]

@Pepe Le Mokko, First of all, I would like to inform you that I do not expect anyone to open the attached sheets to understand what I mean, I always define my problem as much I can. And my title is very clear. That thing is different that you did not understand this post of mine.

This:

Need MD wise all RSE name with commas

means absolutely NOTHING unless you open the workbook to find out what MD and RSE are referring to, so no, your title is NOT completely clear.

Please mind your manners if you wish to receive help here.

[Pankaj jaswani]

You're welcome & thanks for the feedback

Can you help me with this file? The same result but data has duplicacy of RSE names and I want only distinct RSEs name for Particular MD.

[Pankaj jaswani]

@AliGW , Okay Ma'am. Sorry for this. Next time, I will try to explain my title more effectively.

[AliGW]

Thank you.

[Fluff13]

I want only distinct RSEs name for Particular MD.

For 2019 I'm afraid not, but maybe someone else can.

[MarvinP]

Ok Pankaj,
Put this in B2 and pull it down for your answer.

Please Login or Register  to view this content.

See the attached with proof:
Company then Name Comma Separated.xlsx