Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Background Error Checking | Excel Discussion (Misc queries) | |||
file size & error checking | Excel Discussion (Misc queries) | |||
Error Checking for Duplicates in List | Excel Worksheet Functions | |||
Error Checking | Excel Discussion (Misc queries) | |||
Basic Error Checking in Excel VB | Excel Discussion (Misc queries) |