Sampling

[ALex60]

Hello,

I have a excel sheet with about 1000 rows and 60 columns. in each row, the first column is a UserID and the rest of the columns have some information for that UserID. I want make a sample of 500 of 1000 records. how can I do it?
example:
say this is my dataset before sampling:

userID spsID Name
668 41089 Playing
2329 41627 Eating
681 38411 Driving
674 38481 Drinking
674 38459 Sleeping
672 41736 Reading
672 41228 Sitting
731 38867 Driving
672 38323 Sitting
749 39044 Driving

after sampling I want to have something like this:
userID spsID Name
674 38481 Drinking
749 39044 Driving
2329 41627 Eating
668 41089 Playing
672 38323 Sitting
Note: I have also downloaded Data analysis for my excel.

Thanks a lot

[shg]

Pick a blank 1000-row range. In one column, enter =RAND(). In the next, enter sequential numbers 1-1000. Sort the two-column range by the random numbers. The top 500 rows of the (formerly) sequential numbers are 500 random records.

[ALex60]

didnt quite get it. could you explain more clearly?

[NBVC]

Is that a better title than the one I asked you to change here?:

http://www.excelforum.com/excel-gene...-sampling.html