| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenating results of Conditional statement
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenating results of Conditional statement
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 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenating results of Conditional statement
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 - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenating results of Conditional statement
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenating results of Conditional statement
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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenating results of Conditional statement
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Emily Warren" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for concatenating text with results from calculation | Excel Discussion (Misc queries) | |||
| Retrieve VLOOKUP results based upon a conditional statement | Excel Discussion (Misc queries) | |||
| Is there a formula for conditional concatenating? | Excel Worksheet Functions | |||
| Sum up results from If statement | Excel Worksheet Functions | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
Linear Mode
