how can i scramble data for a sweepstakes?

[Ro]

How can i scramble data for a sweepstakes?

 

[Gary''s Student]

Use the RAND() function

 

[redbird]

If you want to get fancy, see
http://www.cpearson.com/excel/ShuffleArray.aspx