Q: How to put approx X cell contents in a random order on a form?

[BobbaFet]

Hi all,

I'm trying to make a spreadsheet that puts X records in a random order. I need this to create schedules for when people have to work.

Thanx allot,

BobbaFet Everyone has a right to my opinion.
E-mail me at cwcon@programmer.net

http://cwcon.50megs.com/

Be a nice guy 'n press that little ol'
VVV---(this one) for me ;-)

 

[Hasit]

Can you clarify what you are trying to achieve. I am not sure I understand the question.

 

[Dreamboat]

If you're trying to "draw names" at random, try the RAND function.

Insert a new column next to the employee's name. Next to the first employee, type =round(rand(),3) into the cell. It generates a random number with 3 digits. The odds of the same number appearing twice are very small. So, copy the formula down to the last employee. Don't move! Hit Copy, hit Edit-Paste special-Values. Click on just one of the cells, and sort. This should give you a randomly sorted list of your employees.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Dreamboat]

PS. If you're going to use it again and again, put the formula in and save the file. Then do the copy/paste values. Close the file without saving it. Whenever you want to get a new random sort list, just open the file or hit the F9 key.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[BobbaFet]

Thanx for your replies,

What I am trying to to do is this:
Say I have 40 names in a column. I want that column to
be in a random order every time I create a new schedule,
so I can just copy and paste it when I create a worksheet.
This is meant for Microsoft Excel 2000.

Sorry if I misinformed you.


Thanx allot,

BobbaFet Everyone has a right to my opinion.
E-mail me at cwcon@programmer.net

http://cwcon.50megs.com/

Be a nice guy 'n press that little ol'
VVV---(this one) for me ;-)