Enter =RAND() in K1 & fill down to K2790. Sort all columns by col K. The
first 50 are your random selection of 50 items.
Bob Umlas

"Pandorah" wrote in message
...
Hi again

Toppers: My sheet is from A1 to J2790. The information on the sheet is
ID
numbers, names, dates, and then various "number" columns. Out of 2790
employees I am trying to get a random sample of 50 with all columns
included.
I was following the Excel Help instructions on Random Sampling to attempt
this.

Bernd P: I tried your below formula and I seem to be having difficulties.
It tells me it does not recognize it (#NAME?)

=TRANSPOSE(INDEX(Sheet1!A1:J2790,vbUniqRandInt(50, 2790),ROW(1:10)))

Am I typing it wrong? Missing a step maybe? I'm fairly new at using
Excel.

Thank you both!!!
:0)

"Pandorah" wrote:

This may be a simple issue and I'm just missing the easy answer but ...
With Excel 2003...I am trying to get a random sample of 50 employees from
a
spreadsheet. I've figured out how to do that however I only get the
employee
id numbers in my output. I would like my output to contain all the
information on that row for each employee. Is there a way to do that?
Everything I've tried gives me an error message about columns not having
a
numeric value.
Thanks