Okay, what I would like to do is take any roles worked on a certain
project from each of our staff members' timesheets and concatenate the
names of those roles in a cell on another worksheet. So for example,
Amy's timesheet would include a row for Project A with the role
"Developer" and another row for Project A with the role "Team". I
would like these to have these roles show up in a cell next to Amy's
name under the Project A section. It would look like this: "Developer,
Team". Example of how I'd like it to look:

Worksheet 1: Amy's timesheet

Column A Column B

PROJECT ROLE
Project A Developer
Project A Team
Project B
Project C Business Anyalyst

Worksheet 2: All staff hours worked on a given project

Column A Column B

PROJECT ROLE
Project A Developer, Team

Hope this is clear enough. Let me know if you need more information.

On Oct 5, 7:13*pm, "Ashish Mathur" wrote:
Hi,

The question is not cleat. *What is the purpose of worksheet 1. *Be clear
about the questions and please post before/after examples

--
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 -