Thanks Martin, the file looked hopeful, but I have problems with it.
I downloaded but when I opened the file I got a "Run time error 9"
"Subscript out of range"
"MartinW" wrote:
Sounds like a job for superman!
Or in this case Bob Phillips. Take a look at Bob's site here.
http://www.xldynamic.com/source/xld.....Download.html
HTH
Martin
"GIdunno" wrote in message
...
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?