I have two workbooks, Schedule(in military time) and another Floorplans(days
on different worksheets). As I fill in my schedule with start times I want it
to place the names in the corresponding time slot on the floorplan. My
schedule has up to 5 people with the same range however 2-4 people may have
the same start time for a single day. If I have Friday in Column C and the
times from C2:C40 can I get excel to plug those into the Floorplan with a
formula that can deal with the duplicate times?