Multiples....

.....any takers?......

I know you said the list was varible, but do you know the minimum and
maximum of the range? And, are any decimals imvolved, or just whole
numbers? Will you always be looking for the end result of 100, or is that
varible also?

Vaya con Dios,
Chuck, CABGx3


"Cam" <Cam.27cbvm_1146842700.6306@excelforum-nospam.com> wrote in message
news:Cam.27cbvm_1146842700.6306@excelforum-nospam.com...
>
> ....any takers?......
>
>
> --
> Cam
> ------------------------------------------------------------------------
> Cam's Profile:
http://www.excelforum.com/member.php...o&userid=27836
> View this thread: http://www.excelforum.com/showthread...hreadid=538118
>

Hi Clr,

Sorry for the delay, for some reason I am not getting reply notification emails?

The list is variable and the mins & maxs are 1 & 100, all whole numbers. The result needed is also a variable whole number.

Hope that helps, thanks again

ONe more thing.......what is the maximum quantity of numbers in the list,
100?, or some smaller quantity?

Vaya con Dios,
Chuck, CABGx3


"Cam" <Cam.27nh9m_1147362901.2256@excelforum-nospam.com> wrote in message
news:Cam.27nh9m_1147362901.2256@excelforum-nospam.com...
>
> Hi Clr,
>
> Sorry for the delay, for some reason I am not getting reply
> notification emails?
>
> The list is variable and the mins & maxs are 1 & 100, all whole
> numbers. The result needed is also a variable whole number.
>
> Hope that helps, thanks again
>
>
> --
> Cam
> ------------------------------------------------------------------------
> Cam's Profile:
http://www.excelforum.com/member.php...o&userid=27836
> View this thread: http://www.excelforum.com/showthread...hreadid=538118
>

Hi, 20 would be the maximum.

Cheers. Cam

All-righty then......
To reiterate:
We are looking for a means to determine the smallest quantity of numbers,
(including multiple numbers) from a list of up to 20 numbers that will equal
a variable target value. All numbers and target numbers are whole numbers,
no decimals or fractions are involved. The numbers themselves range from 1
to 100 and the list will always contain a 1, so in fact "every" target value
may be attained by a worse-case (actually BEST case) multiple of "1 x
itself"..........walla!, the answer could always be "1 x the target number",
unless of course the actual target number itself is also within the
list.........did I miss something?

Vaya con Dios,
Chuck, CABGx3






"Cam" <Cam.27nymm_1147385401.7764@excelforum-nospam.com> wrote in message
news:Cam.27nymm_1147385401.7764@excelforum-nospam.com...
>
> Hi, 20 would be the maximum.
>
> Cheers. Cam
>
>
> --
> Cam
> ------------------------------------------------------------------------
> Cam's Profile:
http://www.excelforum.com/member.php...o&userid=27836
> View this thread: http://www.excelforum.com/showthread...hreadid=538118
>

Spot on......

Thanks for helping.

Cam