ExcelBanter - The opposite of the "sort" function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - The opposite of the "sort" function (https://www.excelbanter.com/excel-worksheet-functions/136266-opposite-sort-function.html)

[email protected]

The opposite of the "sort" function

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

JE McGimpsey

The opposite of the "sort" function

see

http://www.mcgimpsey.com/excel/udfs/...noreplace.html

In article .com,
wrote:

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

[email protected]

The opposite of the "sort" function

Exellent solution! thanks!

Teethless mama

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?

All times are GMT +1. The time now is 12:12 AM.