Need Help With Excel Homework..
Any experts out there ?
Any experts out there ?
Participate on our website and join the conversation
This topic is archived. New comments cannot be posted and votes cannot be cast.
Responses to this topic
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.
