Need Help With Excel Homework..
This is a discussion about Need Help With Excel Homework.. in the Slack Space category; Any experts out there ?
Any experts out there ?
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
May 17
May 17
0
1 minute
Responses to this topic
What kind of help do you need. LOL I'M not a pro but I know a thing or too.
Cheers
Cheers
OP
How would you go about randomly sampling 5 names from a list of 8?
do they have to be unique? ie. can the same name be picked more than once?
OP
nope they dont have to be unique...
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.
=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.
OP
....Live The Dream....
