My numbers are in A1 to G120, I will try to modify this formula. Thanks

"Ragdyer" wrote:

Say your list of ticket numbers is in A1 to A20.

Try this formula:

=INDEX(A1:A20,INT(RAND()*20)+1)

Each time you hit <F9, you'll get a new random pick.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"TLC" wrote in message
...
If I have a table of values, is there a way to randomly select one of the
cell's values?
For example, I have a table of ticket numbers. They are not in any order
and
they are not all inclusive. How can I randomly choose on of the ticket
numbers to be a winning ticket?