ExcelBanter - mixing up a list

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - mixing up a list (https://www.excelbanter.com/excel-discussion-misc-queries/197819-mixing-up-list.html)

dkb43

mixing up a list

I have imported into Excel (2000) a list that comes in alpha order. I want
the list in random order. Is there a way, in Excel, to randomize the list?

Gary''s Student

mixing up a list

If the list is in column A, then in B1 enter:
=RAND() and copy down.

Then sort cols A & B by column B
--
Gary''s Student - gsnu200798

"dkb43" wrote:

I have imported into Excel (2000) a list that comes in alpha order. I want
the list in random order. Is there a way, in Excel, to randomize the list?

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