I choose to use the absolute cell reference notation with dollar signs although in this case it is not necessary since we are not copying our results to other cells. When we put it all together it looks like the following: =INDEX($A$6:$A$25,RANDBETWEEN(1,ROWS($A$6:$A$25))) By combining the results from the first 2 functions, the INDEX() function searches our list and returns the value of the 3rd cell in the list (i.e., Flor McCard) because the RANDBETWEEN() function returned a value of 3.In this case, RANDBETWEEN() combined with ROWS() returned a value of 3. The RANDBETWEEN() function generated a random number between 1 and the value returned from ROWS() (i.e., 20).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |