Try the following formula, substituting the $A:$A with the column letter of
the column that has your data, and the range $A2:$A397 with the range in
column A that contains the values you want to sample.

=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A2:$A397)),RAND BETWEEN(1,1))

Copy the formula down x number of rows based on the number of samples you
want, where 10 samples = 10 rows.

Hope this helps.
--
Kevin Backmann


"Confused student" wrote:

Im a uni student and i have a worksheet with 474 data entries. I need to
create a random sample and i have no idea how to do it. I have instructions
for excel 2003, but i have excel 2007. Please help asap!!!!!