Index / Search and textjoin based off multiple conditions

jbarrick007

New Member
Joined
Jul 9, 2020
Messages
36
Office Version
  1. 365
Platform
  1. Windows
I have a workflow spreadsheet that im trying to selectively join data. I am using some helper columns but trying not to use to many.

I have received help already on all the tasks assigned to a milestone using the following formula. =IF(ISNUMBER(FIND(".",A2)),TEXTJOIN(CHAR(10),1,FILTER(H2:I$1000,LEFT(B2:B$1000,LEN(A2)+1)=A2&".","")),"")
However I want to be able to narrow it down so that in another column Im only combining tasks assigned to a particular person.

How would I change the above formula to include and IF AND or FILTER based off Column L?

Thank you for all the great support.

Phase 7 - Project Workflow Calculator (V1.3.3).xlsx
ABDEFGHILN
1Workflow #Task #DurationStartFinishPhase NameMilestone NameKey Milestone TasksRolesGoal
21.031.03.001 wks5/26/207/18/2020»Planning| ESTABLISH PROJECT NEEDS(FR, FO)| ESTABLISH PROJECT NEEDS • Gather Property data and add to Proposal plan (FR) • Prepare assumptions, questions, and materials for clients. (FR) • Prepare for and hold meeting (FR) • Gather client remarks (FR)
31.03.012 wks5/26/207/19/2020• Gather Property data and add to Proposal planFR
41.03.023 wks5/27/207/20/2020• Prepare assumptions, questions, and materials for clients.FR
51.03.034 wks5/28/207/21/2020• Discuss assumptions with Property ManagersFO
61.03.045 wks5/29/207/22/2020• Schedule an Investigation MeetingPO
71.03.056 wks5/30/207/23/2020• Prepare for and hold meetingFR
81.03.067 wks5/31/207/24/2020• Gather client remarksFR
91.03.078 wks6/1/207/25/2020• Update draft DR-24 and POR package as neededPO
101.03.089 wks6/2/207/26/2020• Send a Meeting Follow-up LetterFO
111.041.04.0010 wks6/3/207/27/2020| POR ADOPTION(PO)
121.04.0111 wks6/4/207/28/2020• Property MGMT approves POR conceptPO
1322.00.0012 wks6/5/207/29/2020»Design
142.012.01.0013 wks6/6/207/30/2020| CREATE PROJECT BUDGET(EST,CG,FR)| CREATE PROJECT BUDGET • Property MGMT approves Budget (FR)
152.01.0114 wks6/7/207/31/2020• ESTIMATOR Prepares BudgetEST
162.01.0215 wks6/8/208/1/2020• CNST Team finalizes BudgetCG
172.01.0316 wks6/9/208/2/2020• Property MGMT approves BudgetFR
Sheet12
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,969
Office Version
  1. 365
Platform
  1. Windows
Maybe something like

=IF(ISNUMBER(FIND(".",A2)),TEXTJOIN(CHAR(10),1,FILTER(H2:I$1000,(LEFT(B2:B$1000,LEN(A2)+1)=A2&".")*ISNUMBER(SEARCH("FR",L2:L$1000)),"")),"")

Particular person of interest shown in bold.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,970
Messages
5,599,108
Members
414,288
Latest member
horizon2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top