randomly select numbers

  • Thread starter Thread starter jollycarrier
  • Start date Start date
J

jollycarrier

:confused: Hi,
Is there a way that I can randomly select two, three or more numbers
from a row containing 10 numbers
 
jollycarrier said:
:confused: Hi,
Is there a way that I can randomly select two, three or more numbers
from a row containing 10 numbers
Click to expand...


Add a help row, put =RAND() in each adjacent cell, select both rows ans
sort by the help row, then just select the first 2, 3 cells

Regards,

Peo Sjoblom
 
Back
Top