G
Guest
I am using 20 cells. I want to process a random number between 1-20 with our repesting the any number.
N
Norman Harker
Hi KampinKeiths!
One way:
Insert numbers 1 - 20 in A1:A20
In B1:
=RAND(A1)
Copy down to B20
In C1:
=INDEX($A$1:$A$20,RANK(B1,$B$1:$B$20),1)
Copy down to C20
But note that RAND is volatile and the result will change each time
the sheet recalculates.
You can use Copy > Edit > Paste Special > Values > OK
Alternatively:
D1:
=C1
Copy down to D20
Apply Copy > Edit > Paste Special > Values > OK to D1
20
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
One way:
Insert numbers 1 - 20 in A1:A20
In B1:
=RAND(A1)
Copy down to B20
In C1:
=INDEX($A$1:$A$20,RANK(B1,$B$1:$B$20),1)
Copy down to C20
But note that RAND is volatile and the result will change each time
the sheet recalculates.
You can use Copy > Edit > Paste Special > Values > OK
Alternatively:
D1:
=C1
Copy down to D20
Apply Copy > Edit > Paste Special > Values > OK to D1
20--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
T
Tushar Mehta
For other options, see the Excel/Tutorials/Random Selection page of my
web site.
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
web site.
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions