Excel Random Number Generator Code.

[cpatel13]

Hie all,

Basically i am creating a excel sheet where i would be required to have random numbers in a particular range and in multiples for 5 and all the numbers generated should have the total which is entered. Let me elaborate

Input Number- 136400
Random Numbers Range- 12000 to 15000 (Range can be changed accordingly)
Random Numbers Generated
14250
13750
12900
12750
15000
14700
13930
14260
12860
12000

Random Number's total Should match the Input Number
Also the Random Number should not be repeated twice same in the same sequence.

I have Tried to have a look on various forums, but didn't got a proper match for what i was looking for.

Thanks,

 

[Special-K99]

To generate random numbers and not repeat base something on this.

Random list, no duplicates
A1:A3000 Enter the list of names/numbers to be used in this case generate the numbers 12000 to 15000
B1:B3000 =RAND()
C1:C3000 =INDEX(A$1:A$3000,MATCH(SMALL(B$1:B$3000,ROW()),B$1:B$3000,0))