Sorry, I should have said this:

"If you now want a randomly selected set of five column A values, just
select
any five contiguous values in column A."

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"mnpremo" wrote in message
...
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