Help,

I'm working on a work rota,
I've got a list of staff in column A and there are 5 duties they could be
assigned to in columns B C D E & F, I need to randomly assign each member of
staff a duty without any member appearing twice.

Any help is appreciated.

Say your headers are in Row1, and names are in A2 to A6.
Duties are listed in Z1 to Z5.

In Y1 enter:
=Rand()
and copy down to Y5.

In B2 enter:
=INDEX($Z$1:$Z$5,RANK(Y1,$Y$1:$Y$5))

And copy down to B6.

This will give you a random list of duties next to each name, where every
hit of <F9 will give you a list of new random choices.

You can set calculation to manual to retain the list display until <F9 is
hit.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"LaDdIe" wrote in message
...
Help,

I'm working on a work rota,
I've got a list of staff in column A and there are 5 duties they could be
assigned to in columns B C D E & F, I need to randomly assign each member of
staff a duty without any member appearing twice.

Any help is appreciated.

Thanks very much, That works a treat.


"RagDyeR" wrote:

Say your headers are in Row1, and names are in A2 to A6.
Duties are listed in Z1 to Z5.

In Y1 enter:
=Rand()
and copy down to Y5.

In B2 enter:
=INDEX($Z$1:$Z$5,RANK(Y1,$Y$1:$Y$5))

And copy down to B6.

This will give you a random list of duties next to each name, where every
hit of <F9 will give you a list of new random choices.

You can set calculation to manual to retain the list display until <F9 is
hit.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"LaDdIe" wrote in message
...
Help,

I'm working on a work rota,
I've got a list of staff in column A and there are 5 duties they could be
assigned to in columns B C D E & F, I need to randomly assign each member of
staff a duty without any member appearing twice.

Any help is appreciated.

You're welcome, and thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LaDdIe" wrote in message
...
Thanks very much, That works a treat.


"RagDyeR" wrote:

Say your headers are in Row1, and names are in A2 to A6.
Duties are listed in Z1 to Z5.

In Y1 enter:
=Rand()
and copy down to Y5.

In B2 enter:
=INDEX($Z$1:$Z$5,RANK(Y1,$Y$1:$Y$5))

And copy down to B6.

This will give you a random list of duties next to each name, where
every
hit of <F9 will give you a list of new random choices.

You can set calculation to manual to retain the list display until <F9
is
hit.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"LaDdIe" wrote in message
...
Help,

I'm working on a work rota,
I've got a list of staff in column A and there are 5 duties they could
be
assigned to in columns B C D E & F, I need to randomly assign each
member of
staff a duty without any member appearing twice.

Any help is appreciated.