Have a review of the attached to see if it meets your requirements.
In B2 of Shifts by Name sheet:
In B3:
This formula is an array formula and must be confirmed with CTRL+SHIFT+ENTER keys not just ENTER
Because your data in Schedule sheet is in alternate columns, you can't just copy across. After you copy these to cells across, you will have to adjust the B$1:B$200 range to D$1:D$200 and so on.
Then you can copy B2:H3 cells and paste to each white cell in column B and they should give correct results.
(Note: This all assumes the person appears only once in a give day... otherwise it will take their last entries only)>Attachment 108254
Bookmarks