2 Replies Latest reply: Nov 5, 2014 10:55 AM by Phil Speight RSS

    Help Linking tables (using Interval Match)

    Phil Speight

      I have 2 tables which I need to link but I am having problems with.

       

      I have a list of shifts, by person, by date.  I also have a table to show which dept they were in on a given date.

       

      Is there a way I can create an output based on how the tables are configures.

       

      Please see my excel example

       

       

      Thanks in advance

       

       

       

      Phil