Hi,
Download and install the following addin -
http://www.download.com/Morefunc/300...-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 MVP
www.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.