Let's say the data is in A1:A100 and you want a sample of 4
In B1 enter =RANDBETWEEN(1,1000) and copy down the column
In C1:C4 enter 1,2,3,4
In D1 enter =INDEX($A$1:$A$100,LARGE($B$1:$B$100,C1), copy down to D4
This gives four from the data, press F9 to resample
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"random selection of data" <random selection of
wrote in message
...
how do we select a small sample of data randomly froma given set of large
data in excel