Hi,

I modified a copy Myrna Larson's code (for permutations and combinations) to
calculate the nearest set of values to 100,000 for a subset of 6 five digit
numbers from a set of 20 randomly generated numbers.

Code can be found at the link below which was copied from a previous reply
by Tom Ogilvy to a posting on Combinations and Permutations ; if this link
fails, search on "Permutations and Combinations" in this NG to find Tom's
reply):

http://groups.google.com/groups?selm...&output=gplain

If you look at this and need the code changes (only a few lines) , then
repost.

HTH

"RED" wrote:



"Bernie Deitrick" wrote:

Red,

It is impossible to add 6 digit numbers to get to 100,000, which is the
lowest possible 6 digit number. Perhaps you have mis-stated your problem.

(And, no need to type in CAPS - it's hard to read....)

HTH,
Bernie
MS Excel MVP


"RED" wrote in message
...
Sorry my mistake i mean 5 digit.


I HAVE A GROUP OF 14 TO 20 5 DIGIT NUMBERS ALL POSITIVE.I NEED TO FIND THE
RIGHT SET OF OF NUMBERS FROM THIS GROUP THAT WILL ADD UP THE CLOSEST TO
100,000 WITHOUT GOING UNDER.