Error Checking
I am making a schedule in Excel and have work areas numbered 1 through 17.
My rows list each employee and the columns list the day of the week, I want
to check myself that I have all areas covered. Is there a simple function
that would tell me if I was missing a number in a column (day of the month)
and which was missing? Here is an example of what I have set-up:
June
1 2 3 4
Name
Jack Handy 1 2 3 3
Hem Roids 3 4 2 1
Buck Shot 5 6 1 3
Work areas: 1=bench a 4=bench d
2=bench b 5=bench e
3=bench c
Thanks
|