Re: Random Function in Excel
Steve & Shannon Cook <cookcafe@...>
toggle quoted messageShow quoted text
Thanks Chris! This is just what I was looking for! Works Great!
Steve and Shannon Cook
Steve on Dice World: Steve6009
Steve on Twitter: @SteveCook67
Today I married my best friend.
The one that I laugh with, live for, love.
October 11, 2003
From: email@example.com [mailto:firstname.lastname@example.org] On Behalf Of Chris Chaffin
Sent: Friday, July 15, 2016 6:36 PM
Subject: Re: Random Function in Excel
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,