Red,

Email me privately (take out the spaces and change the dot to . ) and I
will send you a workbook that will do what you want.

HTH,
Bernie
MS Excel MVP


"RED" wrote in message
...


"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.