I add a helper column with the Rand() function in each cell. It puts a
random number in each cell. I then sort by that column and take the top ten
percent or whatever I need for the sampling.

"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!!!!!