Is there an easy way to count when adjacent cells contain same data?

[mrarcade]

I am working on a file for setting up the work schedule for a smal
three shift facility. I have it doing everything I want except on
thing. It copies the master schedule to each person's individua
schedule and highlights each worker's schedule. It tracks how man
days a person works each week and flags when overtime is created.

I would like to flag when a double shift is created. I am hoping ther
is an easier way than nesting a bunch of IF's. Here is an html versio
of the file so far so you can see how I have the sheets laid out:

http://www.bright.net/~mrarcade/temp/33all 05-08-07.htm

The start date is entered on the Master page...as well as any schedul
changes. All other sheets get their data from the Master sheet. Wha
I want to do is add a sheet that will flag anytime the same worke
number appears in back to back shifts. What seems like it will make i
hard is the fact it has to compare different numbers of cells (2 vs 6
and also look from the bottom of a column (2nd shift) to the top of th
next column. If needed, I will make an array that would eliminate thi
by stacking all days in one column with the date in an adjacen
column.

In the example, worker 23 (Ron) works 3 doubles...
Aug 19, 2nd shift + Aug 20, 3rd shift
Aug 27, 2nd shift + Aug 28, 3rd shift
Aug 28, 2nd shift + Aug 29, 3rd shift

I would like a sheet that would at least flag if at least one doubl
shift exist. Ideally I would like it to return either the date or th
worker number so it can easily be found.

Thanks in advance for any and all advice!

MrArcad

 

[Bob Phillips]

Why isn't Ron working a double on 7th/8th Aug?

Can you give some cell info? Looking at it I think the layout may suit your
aesthetic needs, but it might make a solution difficult. It looks like
merged cells, variable numbers etc.