If statement help please

ariel20029

Board Regular
Joined
Jun 20, 2013
Messages
97
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

ariel20029

Board Regular
Joined
Jun 20, 2013
Messages
97
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,730
Messages
5,524,492
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top