Spreadsheet: 750302d1633374304-need-a-formula-or-advanced-filter-to-show-which-cells-in-one-table-are-found-in-another-book1
Sheet: Sheet1

Employee Number | Weekday | Shift | es1 |  |  | Weekday | Shift | Employee Number | Column1 | es2
3241 | Mon | 2 |  |  |  | Mon | 1 | 3267
3241 | [NAME] | 8 |  |  |  | Mon | 2 | 3267
3241 | Wed | 2 |  |  |  | Mon | 2 | 3257
3241 | Thu | 2 |  |  |  | Mon | 2 | 3247
3241 | Fri | 2 |  |  |  | Mon | 3 | 3246
3242 | Mon | 1 |  |  |  | Mon | 3 | 3244
3242 | Mon | 5 |  |  |  | Mon | 4 | 3267
3242 | [NAME] | 1 |  |  |  | Mon | 5 | 3246
3242 | [NAME] | 5 |  |  |  | Mon | 5 | 3251
3242 | Wed | 1 |  |  |  | Mon | 6 | 3253
3242 | Wed | 5 |  |  |  | Mon | 7 | 3265
3242 | Thu | 1 |  |  |  | [NAME] | 1 | 3267
3242 | Thu | 5 |  |  |  | [NAME] | 2 | 3246
3242 | Fri | 1 |  |  |  | [NAME] | 3 | 3267
3242 | Fri | 5 |  |  |  | [NAME] | 4 | 3255
3242 | Sat | 1 |  |  |  | [NAME] | 5 | 3256
3242 | Sat | 5 |  |  |  | [NAME] | 5 | 3251
3242 | Sun | 1 |  |  |  | [NAME] | 6 | 3253
3242 | Sun | 5 |  |  |  | [NAME] | 7 | 3265
3243 | Mon | 1 |  |  |  | Wed | 1 | 3242
3243 | [NAME] | 3 |  |  |  | Wed | 2 | 3256
3243 | Thu | 1 |  |  |  | Wed | 3 | 3243
3244 | Mon | 7 |  |  |  | Wed | 4 | 3256
3244 | [NAME] | 7 |  |  |  | Wed | 5 | 3263
3244 | Wed | 7 |  |  |  | Wed | 7 | 3244
3244 | Thu | 7 |  |  |  | Wed | 5 | 3251
3244 | Fri | 7 |  |  |  | Wed | 6 | 3253
3244 | Sat | 7 |  |  |  | Wed | 7 | 3265
3244 | Sun | 7 |  |  |  | Thu | 1 | 3267
3245 | Mon | 3 |  |  |  | Thu | 2 | 3246
3245 | [NAME] | 4 |  |  |  | Thu | 3 | 3257
3245 | Thu | 4 |  |  |  | Thu | 3 | 3247
3245 | Fri | 3 |  |  |  | Thu | 4 | 3263
3245 | Sat | 2 |  |  |  | Thu | 5 | 3267
3245 | Sat | 4 |  |  |  | Thu | 2 | 3244
3245 | Sun | 4 |  |  |  | Thu | 5 | 3251
3246 | Mon | 4 |  |  |  | Thu | 6 | 3253
3246 | [NAME] | 1 |  |  |  | Thu | 7 | 3265
3246 | Thu | 1 |  |  |  | Fri | 1 | 3246
3246 | Fri | 4 |  |  |  | Fri | 2 | 3257
3246 | Fri | 5 |  |  |  | Fri | 2 | 3247
3246 | Sat | 4 |  |  |  | Fri | 3 | 3263
3247 | Thu | 2 |  |  |  | Fri | 4 | 3267
3247 | Fri | 2 |  |  |  | Fri | 5 | 3246
3247 | Sat | 5 |  |  |  | Fri | 5 | 3251
3251 | Mon | 5 |  |  |  | Fri | 6 | 3253
3251 | [NAME] | 5 |  |  |  | Fri | 7 | 3265
3251 | Wed | 5 |  |  |  | Sat | 1 | 3257
3251 | Thu | 5 |  |  |  | Sat | 1 | 3247
3251 | Fri | 5 |  |  |  | Sat | 2 | 3255
3251 | Sat | 5 |  |  |  | Sat | 3 | 3256
3251 | Sun | 5 |  |  |  | Sat | 3 | 3256
3252 | Wed | 1 |  |  |  | Sat | 5 | 3263
3252 | Thu | 3 |  |  |  | Sat | 5 | 3260
3252 | Sat | 1 |  |  |  | Sat | 6 | 3253
3252 | Sun | 1 |  |  |  | Sat | 7 | 3265
3252 | Sun | 3 |  |  |  | Sun | 1 | 3267
3253 | Mon | 6 |  |  |  | Sun | 2 | 3255
3253 | [NAME] | 6 |  |  |  | Sun | 3 | 3256
3253 | Wed | 6 |  |  |  | Sun | 4 | 3243
3253 | Thu | 6 |  |  |  | Sun | 5 | 3263
3253 | Fri | 6 |  |  |  | Sun | 5 | 3260
3253 | Sat | 6 |  |  |  | Sun | 6 | 3253
3253 | Sun | 6 |  |  |  | Sun | 7 | 3265
3254 | Mon | 5
3254 | [NAME] | 5
3254 | Wed | 5
3254 | Thu | 5
3254 | Fri | 5
3255 | Mon | 2
3255 | Wed | 3
3255 | Sun | 2
3256 | Mon | 4
3256 | Wed | 4
3256 | Fri | 3
3256 | Sat | 3
3257 | Thu | 2
3257 | Fri | 2
3257 | Sat | 5
3260 | Mon | 5
3260 | [NAME] | 5
3260 | Wed | 5
3260 | Thu | 5
3260 | Fri | 5
3260 | Sat | 5
3260 | Sun | 4
3260 | Sun | 5
3261 | Mon | 3
3261 | Mon | 4
3261 | [NAME] | 4
3261 | Wed | 3
3261 | Wed | 4
3261 | Thu | 4
3261 | Fri | 3
3261 | Fri | 4
3261 | Sat | 2
3261 | Sat | 3
3261 | Sun | 2
3261 | Sun | 4
3262 | Mon | 2
3262 | [NAME] | 2
3262 | Wed | 2
3262 | Thu | 2
3262 | Fri | 2
3263 | [NAME] | 3
3263 | Thu | 3
3263 | Fri | 4
3263 | Sun | 3
3264 | Wed | 1
3264 | Thu | 3
3264 | Fri | 1
3264 | Sat | 1
3264 | Sun | 1
3264 | Sun | 3
3265 | Mon | 7
3265 | [NAME] | 7
3265 | Wed | 7
3265 | Thu | 7
3265 | Fri | 7
3265 | Sat | 7
3265 | Sun | 7
3267 | Wed | 5
3267 | Thu | 5
3267 | Sun | 5