Special Random Numbers' Distribution
 

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.
--
Thanx & Best Regards,

Faraz!

Special Random Numbers' Distribution
 

Check out
http://www.youtube.com/watch?v=SoK9kq-0uXg

--
Jacob


"Faraz A. Qureshi" wrote:

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.
--
Thanx & Best Regards,

Faraz!

Special Random Numbers' Distribution
 

Unfortunately utube's blocked at our OFFICE!
:-(
--
Thanx & Best Regards,

Faraz!


"Jacob Skaria" wrote:

Check out
http://www.youtube.com/watch?v=SoK9kq-0uXg

--
Jacob


"Faraz A. Qureshi" wrote:

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.
--
Thanx & Best Regards,

Faraz!

Special Random Numbers' Distribution
 

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

--
Jacob


"Faraz A. Qureshi" wrote:

Unfortunately utube's blocked at our OFFICE!
:-(
--
Thanx & Best Regards,

Faraz!


"Jacob Skaria" wrote:

Check out
http://www.youtube.com/watch?v=SoK9kq-0uXg

--
Jacob


"Faraz A. Qureshi" wrote:

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.
--
Thanx & Best Regards,

Faraz!

Special Random Numbers' Distribution
 

Hello,

Google for UniqRandInt.

Regards,
Bernd