Closed Thread
Results 1 to 2 of 2

Help with modified gantt chart / index + mulitple match formula

  1. #1
    Registered User
    Join Date
    01-27-2019
    Location
    Exeter, CA
    MS-Off Ver
    Microsoft 365
    Posts
    92

    Help with modified gantt chart / index + mulitple match formula

    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.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Help with modified gantt chart / index + mulitple match formula

    Question moved to the commercial services section. Thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-11-2016, 02:18 AM
  2. Modified Gantt Chart for Inventory
    By aantonio9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 05:45 AM
  3. [SOLVED] Index/Match with mulitple criteria referencing same table
    By mchiappetta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2014, 09:24 AM
  4. Index/Match with mulitple arrays
    By Jeannie2006 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2013, 10:56 PM
  5. Index-Match with mulitple worksheets
    By adamjohnson182 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2013, 08:40 PM
  6. Mulitple Criteria Index,Match or Evaluate issue
    By Journeyman3000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2013, 04:30 PM
  7. Index-match for data on mulitple rows
    By Nadir Soofi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2008, 03:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1