Question: I have a google sheet , with two tabs one containing employees names in one column in sheet 1 , in sheet 2 i am

I have a google sheet , with two tabs one containing employees names in one column in sheet 1, in sheet 2 i am having there daily roster with four columns( for the whole day shifts are divided). In each cell again i assign multiple employees for the same kind of work for the day . Now i want to know how to figure out any one missing from the roster for the day , also see any one assigned twice for the day

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!