Choosing a number

  • Thread starter Thread starter Alan
  • Start date Start date
Alan,

If you just want to get 3 numbers, you could put this formula in 3 cells

=INDIRECT("A"&INT(RAND()*100))

Change the 100 to the size of the column. Note that the values will keep
changing as the worksheet changes.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top