F
Faraz A. Qureshi
How to insert random numbers between 1-50 in cells A1:A10, with a condition
of using a number once only, i.e. no number repeating.
of using a number once only, i.e. no number repeating.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Check out
F
Faraz A. Qureshi
Unfortunately utube's blocked at our OFFICE!
:-(
:-(
J
Jacob Skaria
--Use a helper column say Col B where in B1 to B50 enter the formula =RAND().
This will generate 50 random numbers.
--Now, in A1, enter the formula, =RANK(B1,$B$1:$B$50,1) and copy/drag the
formula down to A10.
--Refresh/press F9 will generate random numbers between 1 and 50
For a VBA solution refer the below from J.E. McGimpsey
http://www.mcgimpsey.com/excel/udfs/randint.html
This will generate 50 random numbers.
--Now, in A1, enter the formula, =RANK(B1,$B$1:$B$50,1) and copy/drag the
formula down to A10.
--Refresh/press F9 will generate random numbers between 1 and 50
For a VBA solution refer the below from J.E. McGimpsey
http://www.mcgimpsey.com/excel/udfs/randint.html
B
Bernd P
Hello,
Google for UniqRandInt.
Regards,
Bernd
Google for UniqRandInt.
Regards,
Bernd