Forum Discussion
Need Help with Making Random selections from chart.
I am working on an Excel spreadsheet to help me stay on top of some extensive vocabulary and grammar points. I want the first row to generate values from a random cell corresponding to cells in the s...
Microsoft's documentation on the INDEX function is weak. The row number argument is not the spreadsheet row number; it's the relative row number within the specified range/array/table, starting from 1. (See 0:36 in the video.) So your example formula should be:
=INDEX($A$2:$A$15,RANDBETWEEN(1,14))