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