spreadsheet that picks words from a list. need help.

**ginaccc** · 05-16-2011, 01:30 AM

i have a list of words. I have an excel sheet that was made by somebody else made that pics 12 words out of this list, and then when you hit f9, it picks 12 more words.

I know the RAND feature picks a number between 0-1

My problem is that the list is so long that the numbers that choose the words are now over 1. So all the words over 1 are not showing up. I tried to put RAND()*2 but then I had a problem with a lot of the words staying the same and not changing when I hit f9.

I also wanted the spreadsheet to have more columns of random words, instead of 12 maybe 15 or 18. I tried to add acouple more columns on the far right, and that didn't help.

Can somebody tell me how to do these things? I attached the spreadsheet so you can see what I mean. I dont understand the command lines at all. I don't do too much complicated stuff in excel, so this is beyond me. I tried to find something like this online, but I couldn't find it.

Thanks,
Gina C.

**JBeaucaire** · 05-16-2011, 02:31 AM

Here you go, a little more straighforward technique. This uses the RAND() formulas in columns D and F to find the largest 12 random numbers created and return the words next to those numbers. Each F9 will generate a new list/order.

There are no other columns or named ranges needed any longer. Put as many words in E and G as you want, just make sure D and F have RAND() formulas to match.