Let's see if we understand this.

You should have the numbers 1 through 17 listed in a column. You want to
check and make sure every one of those numbers is present. List any that are
missing.

Is that what you want?

Assume the range for the numbers is B2:B18

Try this array** formula:

=SMALL(IF(ISNA(MATCH(ROW($1:$17),B$2:B$17,0)),ROW( $1:$17)),ROWS($1:1))

Copy down until you get #NUM! errors meaning all missing numbers have been
returned.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Lost in Microbiology" wrote
in message ...
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