Thread: Error Checking
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lost in Microbiology Lost in Microbiology is offline
external usenet poster
 
Posts: 49
Default 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