Special Random Numbers' Distribution

[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.

 

[Jacob Skaria]

Check out

 

[Faraz A. Qureshi]

Unfortunately utube's blocked at our OFFICE!
:-(

 

[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

 

[Bernd P]

Hello,

Google for UniqRandInt.

Regards,
Bernd