R
Rich
I have a customer who homeschools their children. A friend of theirs gave them an Excel spreadsheet for vocabulary word study. Column A has the words and column B has the definitions. They want to be able to scramble the definitions around so the children have to match the words with definitions. The formula used to do this in Excel is
=INDEX(B1:B5,INT(RAND()*5+1),)
Here's where they need help. They don't have Excel but they have Works 2001. I tried opening the spreadsheet in Works but it said the formula was not recognized. What formula can they use to acomplish the same results but in Works
Thank you
Ric
=INDEX(B1:B5,INT(RAND()*5+1),)
Here's where they need help. They don't have Excel but they have Works 2001. I tried opening the spreadsheet in Works but it said the formula was not recognized. What formula can they use to acomplish the same results but in Works
Thank you
Ric