Thread: The opposite of the "sort" function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default The opposite of the "sort" function
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


" wrote:

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


Reply With QuoteReply With Quote