Re: Random Function in Excel
toggle quoted messageShow quoted text
I have tested the formula below, and it will do exactly what you want. I had to use 3 different functions joined together to get it done, but like I said, it does work very well.
It picks a number between 2 and 200, then it will give you the persons name that is in that cell.
To run the formula again just hit f9, and it will pick another random number and display the name.
If you have any questions regarding the specifics of the formula, you can feel free to ask offlist.
Just copy the formula and paste it in the cell you want your results:
Hope this helps,
On Jul 15, 2016, at 10:58 AM, Steve & Shannon Cook <cookcafe@...> wrote: