JMD 0 Posted May 17, 2001 What kind of help do you need. LOL I'M not a pro but I know a thing or too. Cheers Share this post Link to post
B_2 0 Posted May 17, 2001 How would you go about randomly sampling 5 names from a list of 8? Share this post Link to post
CUViper 0 Posted May 17, 2001 do they have to be unique? ie. can the same name be picked more than once? Share this post Link to post
CUViper 0 Posted May 17, 2001 This should work for you - this of course assumes that your names are in A1:A8, but you can change that to suit your needs. =INDEX(A1:A8,CEILING(RAND()*8,1),1) Be careful when copying this formula around that it doesn't try to 'update' the array location. If you want, you can lock it down with dollar signs - ie. $A$1:$A$8. Also, the INDEX works in (row,column) coordinates. I assumed here that the data is vertical, so the row is random and the column is always 1, the first (and only) column of the array. If your data is horizontal, then make the row 1 and the column random. Share this post Link to post
