generally this is achieved via the use of a "helper"column - another column
adjacent to what you want to sort where you type in a function to generate
random numbers (e.g. =ROUND(RAND()*100,0) ) and then you change this column
from a formula to values (copy it, select it again - edit / paste special -
values) and then you sort of this column to get a "random" sort. The column
can be deleted once you've sorted.
Cheers
JulieD
"golfmoab" <[email protected]> wrote in message
news:[email protected]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks