Randomize Contestant list

[RustyRick]

After the contestant list is completed. And closed.

I need to shuffle into 3 relays.

How do I best do that?

[Richard Buttrey]

Would you give us an example? There's not much to go on so far.....

[RustyRick]

Don't know what more to say. I have a column of say 200 people.

Before they begin to compete I need to break them up into 3 equal sized lists (randomly shuffled), in as much as any group can be divided by 3.

Then print out the 3 lists.

[Richard Buttrey]

Hi,

If there are always the same number of names then put a page break at row 67 & 133 and set the Print area to rows 1:200

In an adjacent helper column enter =RAND() and copy down.
Then sort the two columns using the helper column as the key.
Then print the range.

If the number of names vary then a macro would be necessary to reset the page breaks