I have 2 schedule tables on sheet1 and 2 representing 2 teams. Underneath table one i want a table to see the people names by the shift they work in. And i want that those who are in delegation to by shown in their normal shift which is dispalyed in A2:C2. These will be shown as Name (D) to know that they are in delegation. I need a formula without Aggregate function, one that will work for excel 2003&2007.
Bookmarks