Thanks everyone - these methods work great, but is there any way to generate
all the numbers in random order all at the same time - instead of one by one?

Thanks again!

"B. R.Ramachandran" wrote:

Hi,

If the numbers are listed in column A (say A2:A2001), enter the following
formula in B2.

=INDIRECT("A"&RANDBETWEEN(2,2001))

where the two numbers in the parentheses are the first and last row numbers
of your data range. Fill the formula down in column B to as many random
samples as you want.
The sampling would dynamically change every time Excel recalculates it
(when you open the workbook or whenever you hit the F9 button). If you want
a set of random samples to stay static, you have to do Copy-Paste
Special-Values.
If, in addition to the random samples, you also want to know their cell
addresses,
you could use the following formulas in B2 and C2.

In B2, ="A"&RANDBETWEEN(2,2001)
In C2, = INDIRECT(B2)

and fill down the formulas to as many random samples as you want.

Note: The RANDBETWEEN function is in the Analysis Toolpack. If it is not
available in you Excel, run the Setup program to install the toolPak and then
enable it by using the Add-Ins command on the Tools menu.

Regards,
B. R. Ramachandran




"mnpremo" wrote:

I'm creating an Excel spreadsheet that has several hundred numbers listed (in
no particular order) in the first column. The numbers are all in this
format: 000.00.00.00

I was wondering if Excel has the ability to go through and select several of
these numbers randomly from the column so that I can then have a random
sample from my list of hundreds of numbers.

Thank you-
Maureen