Random Number Generator

[Chetan_raghu]

Hi All,

Is that possible we can create Random number generator in Excel if yes please write a code for me , I want random number in column A .

Thank you very much in advance.


Thanks,
Chetan

[:) Sixthsense :)]

Refer the below link

http://www.cpearson.com/excel/randomnumbers.aspx

[AliGW]

This can be done with a formula. Does the random number have to be unique? Does it have to be in any particular format? What are the lowest and highest numbers you want to use?

[Chetan_raghu]

Need to generate random sequence of numbers with 7 numbers in a sequence, a key number and a repeating number..any number can be repeated but only one repeat within a sequence..set= 1.2.3.5.6.7.8.9.10
Example a. 2.1.3.5.7.3.9
Example b. 5.2.1.6.5.10.8

[shg]

What's a "key number?"

[Chetan_raghu]

1 is the key number

[shg]

You mean the number 1 is always included, and one number (other than 1) is always repeated? What's the range of the other numbers?