If statement help please

[ariel20029]

Hi,
I have column A that has a project ID and a column that has a role related to that project. There can be multiple rows per project:
I am trying to concatenate the multiple roles per project into one cell per project.

Example
Project ID Field ID
A Consultant
A Sr Consultant
A Project Manager
B Project Manager
C Sr Consultant
C Project Manager

The result I am trying to get

A-Consultant,Sr Consultant,Project manager
B-Project Manager
C- Sr Consultant, Project manager
I tried a few variations of if statements but could not get it to work.
Any help is appreciated.

thank you so much,
Sharon

 

[philwojo]

Try this link and see if this UDF will work for you, seems like it might be a good fit for this situation:

https://www.extendoffice.com/docume...eturn-multiple-values-separated-by-comma.html

 

[ariel20029]

Hi,
I have column A that has a project ID and a column that has a role related to that project. There can be multiple rows per project:
I am trying to concatenate the multiple roles per project into one cell per project.

Example
Project ID Field ID
A Consultant
A Sr Consultant
A Project Manager
B Project Manager
C Sr Consultant
C Project Manager

The result I am trying to get

A-Consultant,Sr Consultant,Project manager
B-Project Manager
C- Sr Consultant, Project manager
I tried a few variations of if statements but could not get it to work.
Any help is appreciated.

thank you so much,
Sharon

Hi thank you, but that code did not work. It did not loop and only returned the first item it found. I probably did something wrong but I followed the directions twice.. thanks for trying though.

 

[philwojo]

What did you put in to your formula once you installed the UDF?