Scrambling Alphabetical order

[Kukainis]

Hi,

is there a way to automatically scramble a list of alphabetically organized data ?

[tom1977]

sort method?

[Kukainis]

yes, to sort the data randomly

[Andy Pope]

combine the suggestion and your answer.

Add a helper column which contains the RAND() function and sort on that.

[ABitOfANoob]

How about adding a column at the end/start of your table and populating it with random numbers. Then sort your entire table via the random number column.

=RAND()

HTH

---EDIT---

Damn Andy, you type fast!

[Kukainis]

did the trick, thanks

[Andy Pope]

@ABitOfANoob, a case of being at the right place at the right time