C7 contains the name (column C lists all the people.) D7-AH7 contains dates
during the month for Earle.

I adapted your formula into cel D7 (that is 1 Nov) and plan to copy it to
all the other cells in the same row for each individual. The NAMES won't
change in column C, but the shifts are placed in D-AH columns (D7 is the 1st,
E7 is the 2nd, F7 is the 3rd, etc... for Earle)

"Jim Thomlinson" wrote:

The validation I gave you ensures that the value in C7 id not repeated in C27
or C51. That validation can be copied to other cells so I would assume that
that will take care of the multiple shifts issue??? I have no idea what your
sheet looks like so I am at a bit of a loss in how to get you to the next
step...
--
HTH...

Jim Thomlinson


"GIdunno" wrote:

Thanks Jim, I'm getting closer!!
This works with one small problem. I only get the error alert when I
schedule them all three on the same shift. I also need it if I accidentally
schedule only 2 of them (THAT is a more realistic scenario)

Any way I can 'tweak' it to fit??

"Jim Thomlinson" wrote:

You can use data validation if you want to something like this...
Highlight Cell C7.
Click Data|Validation - Custom
Add the formula
=NOT(OR(C7=C27, C7=C51))

Do the same for Cells C27 and C51 changing the appropriate cell references
to the formula. You may also want to change the error alert...
--
HTH...

Jim Thomlinson


"GIdunno" wrote:

I'm back with another problem :-)
I work a crew schedule; and I have 3 people who cannot work a shift
together. I need something that will NOT allow me to put them on a shift
together. We identify our shifts by D, S, or M (days, swings, mids) So I
cannot have Buck, Earle, or Small working a shift together. (weird rules
about these three)
I can't use conditional formatting for this because I already have used all
3 conditions for another issue.

Is there a way I can "raise a flag" if I schedule 2 or more of them on the
same shift?

Here's an idea of my schedule
Earle is in C7, Buck is in C27, and Small is in C51. If I were putting day
shift together in column D, then D7, D27, and/or D51 cannot match.

Any ideas O' Smart Excel people?