How to insert random numbers that equal a certain number

Bruno Campanini · #7 11-22-2014, 07:50 PM

Quote:

Originally Posted by macropod

You obviously haven't tried the solution I posted...

To show how simple it is to get a series of 75 unique numbers that add to 20000, simply insert:
=INT(317.75-ROW()*4/3)
and copy down to row 75. The sum of the rows will be 20000. Granted, these numbers aren't random, but they also go nowhere near exhausting the possibilities contemplated by the OP.

Well, OP requested 76 random numbers in the range 85 to 645
Your formula gives 75 quasi-successive number in the range 216 to 317.
Honestly you can't consider it neither a solution, nor a pseudo-solution.
Another simpler non-solution is:
Sum 75 successive numbers in the range 227 to 301, plus 200.

The problem is a Linear Programming Problem whose solution can be achieved also with the Simplex Algorithm coded in Excel VBA, but it involves a setup of 561 parameters... which is a very long story.
For sure Mathematica can do the job but it requires either a more complex code or an extraordinary long command line.
Taking into account these difficulties I said Mission Impossible.

Bruno

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling cells with random numbers using loops? (VBA)	Sajj	Excel Programming	4	04-10-2013 02:29 PM
Random number difficulties	ahrinn	Word	12	08-01-2012 01:04 PM
Random number generator for Powerpoint 2011	kala85	PowerPoint	0	11-19-2011 06:16 AM
How to fill a cell with random numbers to do calculations?	zanat0s	Excel	1	06-13-2011 10:33 AM
Display Random Numbers as Transition	greenbutton	PowerPoint	0	03-09-2011 04:43 PM