Help
Any experts out there ?
Page 1 of 1
Need Help With Excel Homework..
#6
CUViper 
- old hand
- Group: Members
- Posts: 1120
- Joined: 23-January 00
Posted 17 May 2001 - 09:45 PM
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.
Share this topic:
Page 1 of 1