ExcelBanter - how can i scramble data for a sweepstakes?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can i scramble data for a sweepstakes? (https://www.excelbanter.com/excel-worksheet-functions/208110-how-can-i-scramble-data-sweepstakes.html)

how can i scramble data for a sweepstakes?

How can i scramble data for a sweepstakes?

Gary''s Student

how can i scramble data for a sweepstakes?

Use the RAND() function
--
Gary''s Student - gsnu200810

"Ro" wrote:

How can i scramble data for a sweepstakes?

redbird

how can i scramble data for a sweepstakes?

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

"Ro" wrote in message
...
How can i scramble data for a sweepstakes?

All times are GMT +1. The time now is 07:55 AM.