Hi again

@Bruno
The second time you got it wrong, it's 75 numbers!!! There is no mentioning that the random numbers may not contain duplicates!!!

Any comment on a perfectly working solution the like "wouldn't work", even by replacing it with a statement like "mission impossible" makes me really cross.


If you don't bother to read the question properly, neither to try out provided solutions, please just keep your wisdoms to yourself.

Offering on this theme a solution involving the simplex algorithm is completely offtopic, you read obviously somewhere something, but can't get loose ends fit.

@Paul
Great solution, efficiently and fast, and quite comfortable when using vba for recalculations!

Cheers

[quote=whatsup;73911]Hi again

@Bruno

The second time you got it wrong, it's 75 numbers!!!
***
Ok, my second fault... waiting for the third one.


There is no mentioning that the random numbers may not contain duplicates!!!
***
Don't be ridiculous!
If you allow duplicates the simplest formula is:
74*a + b = 20000
where:
a = Int(20000/74) = 270
b = 20000 - 74*a = 20


Offering on this theme a solution involving the simplex algorithm is completely offtopic, you read obviously somewhere something, but can't get loose ends fit.
***
You say Simplex Algorithm is off-topic because you never wrote such a code in Excel VBA.
I did it and it works fine!

Would you like to see it?
If you do, you must confirm me in advance that you know how Simplex works.

Ciao
Bruno