Team
I need some assistance with the attached file. Basically I am trying to populate data in a modified Time based Gantt chart from another tab holding data. CONTROL tab lists TEAM, TASK, LOCATION, START TIME, and END TIME or DURATION. This would be modified as tasks, locations, or start times change. PASSWORD tab is a simple pivot table used to consolidate TASK field listed on CONTROL tab and then that information is populated on CHART tab. The CHART tab is modified Gantt chart with fixed Time increments and the condensed TASK information from the PASSWORD tab. What functionality I am struggling with is using possibly an Index + multiple criteria Match formula to find TASK and START TIME from CONTROL tab, match to corresponding TASK and TIME on CHART tab and return LOCATION. Once that piece is working, I need to list LOCATION on CHART tab at all times between START TIME and END TIME, then merge into one cell. Here is an example.
CONTROL TAB
TASK LOCATION START TIME END TIME
MILK / MILKING PEN #25 5:15 AM 6:30 AM
CHART TAB
ON ROW: MILK / MILKING
ON COLUMN: 5:15AM
RESULT: PEN #25
Second request is having the result PEN #25 populate in COLUMNS: 5:15 AM, 5:30 AM, 5:45 AM in CHART TAB.
This request is conditional formatting that is adjacent cells contain the same information, to merge them.
Thank you in advance for your help on this.
Bookmarks