random sequence of numbers

[Joe]

How do I generate a random sequence of numbers? e.g.
simulating pulling the numbers 1 through 25 out of a hat.

 

[J.E. McGimpsey]

One way:

Put the numbers 1 through 25 in A1:A25. Put this in B1 and copy down
to B25:

=RAND()

Select any cell in the A1:B25 and choose Data/Sort. Sort on column B
(ascending or descending, doesn't matter) with no headers. If you
need to save the sequence copy A1:A25 to a different location.

Since RAND() will recalculate after the sort, you can get another
random sequence by choosing Data/Sort again.

 

[Raj Singh]

Hi Joe,

Try:

=randbetween(1,25)

HTH,
Raj

AnalysisWorks Inc
Evidence-Based Analytic Consulting
www.analysisworks.net

Download a free Excel Box Plot add-in:
http://www.analysisworks.net/downloads.htm#BoxPlotPro

 

[J.E. McGimpsey]

Caveat:

Since RandBetween() will produce duplicates within a data set, it
doesn't meet the OP's criterion of "simulating pulling the numbers 1
through 25 out of a hat"

 

[Tom Ogilvy]

put the numbers 1 to 25 in column A.

next to them put the formula

=rand()

then sort both columns using the column with the formula as a key.

This will give you a rand pick of the 25 numbers.