randomly select numbers

J

jollycarrier

:confused: Hi,
Is there a way that I can randomly select two, three or more numbers
from a row containing 10 numbers
 
P

Peo Sjoblom

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
 
Top