How do I scramble a list in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to scramble a list of words so that they are not in an
particular order. Can I do this somehow?
 
The simplest way is to insert =rand() in the cells next to the word column
select both columns and sort by the rand column. If you dont like the order
just sort again.
 
Just run this formula in the cells next to the words then sort both columns:
=RAND()

Regards,
Ron
 
Assuming the words are in individual cells, use a help column
and in the first adjacent cell type

=RAND()


copy down

select both column and sort by the formula column,
then delete the formula column

Regards,

Peo Sjoblom
 
what is a help column?

Peo Sjoblom said:
Assuming the words are in individual cells, use a help column
and in the first adjacent cell type

=RAND()


copy down

select both column and sort by the formula column,
then delete the formula column

Regards,

Peo Sjoblom
Click to expand...
 
It's an unused column that you can use to sort on. So if your words are
in A1:A20, and column B is unused, enter

B1: =RAND()

and copy down to B20. Select A1, then choose Data/Sort... and sort on
column B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to automatically jumble a list of numbers 2
Need to scramble letters in list of words 1
Sorting 2
List of docs in MY DOCUMENTS is scrambled. How to alphabetize? 2
help with sorting 2
Conditional formatting scrambled when combined with sorting in 200 3
Trouble opening an XLS. and XLM. file in Microsoft 2000 2
How do I make scrambled footnotes in good order? 3

Back
Top