LinkBack URL
About LinkBacks
Kukainis 
Hi,
is there a way to automatically scramble a list of alphabetically organized data ?
Hi,
is there a way to automatically scramble a list of alphabetically organized data ?
sort method?
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
yes, to sort the data randomly
combine the suggestion and your answer.
Add a helper column which contains the RAND() function and sort on that.
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!
did the trick, thanks
@ABitOfANoob, a case of being at the right place at the right time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks