greetings:

i have an excel spreadsheet that has > 1000 rows (records). i'd like to randomly select 78 of these rows and place them in another worksheet w/in this file.

any suggestions?

ok, i've gotten a little further, but...

i went to Tools > Data Analysis > Sampling, and i can get 78 random records, selecting the column "id," when is a number field. but the accompanying columns that are text are not coming along with it. any thoughts here?

got a little further. am able to do it w/the rand() function and an advanced filter. but, can get, say 10% of records. i want a specific number of records. any thoughts?