The opposite of the "sort" function

L

lucavilla

I have a list of alphabetically ordered data in a column.
Is there a function for randomizing the order of these data?
 
T

Teethless mama

Let's say your data in A1:A10
In B1: =RAND()
copy from B1 to B10
Select A1:B10 > Data > Sort > Sort by select Column B > select Ascending > OK
 
Top