Thread: I WOULD LIKE TO RANDOMLY GENERATE FROM LIST I CREATE ON SAME PAGE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default I WOULD LIKE TO RANDOMLY GENERATE FROM LIST I CREATE ON SAME PAGE
=offset($A$1,trunc(rand()*9),trunc(rand()*9))

would be an example.

--
Regards,
Tom Ogilvy




"totalmaker" wrote in message
...
i need to have one cell choose between a list of cells i have on the same
page.. i am new to excel and dont know if this can een be done .. help


Reply With QuoteReply With Quote