How to insert random numbers that equal a certain number

Bruno Campanini · #10 11-23-2014, 07:05 AM

Quote:

Originally Posted by macropod

Bruno: You really need to pay attention.

In post #1 the OP clearly said 75 random numbers, not 76.

My reply in post #6 clearly shows how to do that. Granted, I used a different set of boundary numbers, but that is not the point.

My reply to you in post #9 was aimed, not at producing random numbers, but at demonstrating the abject fallacy of your 'impossible!' assertion. The simple fact of the matter is that there is a very large number of possible solutions to the problem, with or without allowing for repeated numbers.

Saying "allowing for repeated numbers" is ridiculous, see my previous post.

The only mathematical way to solve the problem is:
a - calculate the more then 33681*10^90 combination C561,75
b - chose among them the ones whose sum is 20000
(may be they are many millions)
c - choose random among those many millions.

I don't know any PC/Program able to run that job. Did you?

A shortcut could be using a Linear Programming Algorithm such as
the Simplex Algorithm, but it requires a very complex preliminary
set up (there are 561 variables!) and I'm not sure to be able to do so.
Then, as far as the correct and complete and Excel-solution is concerned,
I repeat: Mission Impossible!

Practical solutions are possible, even off-Excel, as long as one can
forget the "random" attribute.

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