On Oct 13, 12:13*am, "Ashish Mathur" wrote:
Hi,

Download and install the following addin -http://www.download.com/Morefunc/3000-2077_4-10423159.html. *Thereafter you
may use the following array formula (Ctrl+Shift+Enter) in cell E5

=SUBSTITUTE(MCONCAT(IF(Sheet1!$B$4:$B$7=D5,Sheet1! C4:C7),","),",FALSE","")

B4:B7 of sheet1 has the project titles
C4:C7 of sheet 1 has the Roles
D5 of sheet2 has the project title

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"Emily Warren" wrote in message

...



Can anyone figure out how to write a formula for the following
problem?

WORKSHEET 1:
Column A = Project Title
Column B = Role

Each project may have multiple rows if a staff member works on the
project in different roles.

WORKSHEET 2:

Concatenate role names found via conditional statement

Column A * * * * * * * * * * Column B

Project 1 * * * * * * * * * * *Project Manager
Project 1 * * * * * * * * * * *Developer
Project 2
Project 3 * * * * * * * * * * *Business Anyalyst

I'd like to take any/all roles performed on a certain project and
concatenate them in a cell on another worksheet.- Hide quoted text -

- Show quoted text -

Thanks very much!