Hi,
Thanks for your reply:

This is all getting off the point, but allow me to clarify things. Th
problem that I set is actually a gross simplification of the actua
situation. The workplace I run is a busy intensive care unit in the UK
There are 70 staff working a mixture of day & night shifts (12h
shifts), with occasional management & study days thrown in. Most wor
13 shifts in 28 days, but some work less. The are many different grade
of staff, which all has to be taken into account. The trouble with
fixed rota pattern is that it although it is easy to write, it tends t
discriminate against women with children, or people who have partner
who work irregular hours. We like to offer a degree of flexible workin
so that our staff with childcare comittments (the majority) can have a
element of choice/flexibility. This does mean that the rota is
nightmare to write. It used to be done by hand on a huge sheet o
paper, and take about 4 days to complete. errors were common. I move
it to excel, and it now takes me one full day. All the adding up o
staff numbers etc are automated, but I still feel that Excel has mor
to offer.

To get back to the point:

The solution to the following problem would be a huge help to me:

How do I get the 'D's in a row to cluster in the way I want (2's
3's), whilst still maintaining the same number in each column?

I would hope to extrapolate the solution to this problem to othe
problems.

Davi

--
dcleav
-----------------------------------------------------------------------
dcleave's Profile: http://www.excelforum.com/member.php...fo&userid=2056
View this thread: http://www.excelforum.com/showthread.php?threadid=39376