Find a net in a column

[bigstevec]

I really hope someone can help me. I'm using Excel 2002 SP3

I have a column of numbers, 1082 of them in total. I know that some of the numbers on the list net to a certain number, say "X". I don't know which of the numbers or even how many of the numbers but, because of other info I have, SOME of the numbers on the list MUST net to X. In order to resolve the issue I'm working on, I have to find which of the 1,082 numbers on the list net to X. The possible number of combinations is staggering (I think it would be 1082 to the second power + 1082 to the third power + etc ...all the way to + 1082 to the 1082th power number of combinations) so you could see why I'd want the computer to do it for me.

Is there a function where I can have excel search for any combination of numbers within the 1,082 that net to X? Know what I mean? It could be two numbers or it could be 1,000. I have no way of telling. Somewhere in this list of numbers are some amount of numbers that net to X.

[Anne Troy]

I think you want something like this, Steve:
http://www.mrexcel.com/pc09.shtml

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"bigstevec" <[email protected]> wrote
in message news:[email protected]...
>
> I really hope someone can help me. I'm using Excel 2002 SP3
>
> I have a column of numbers, 1082 of them in total. I know that some of
> the numbers on the list net to a certain number, say "X". I don't know
> which of the numbers or even how many of the numbers but, because of
> other info I have, SOME of the numbers on the list MUST net to X. In
> order to resolve the issue I'm working on, I have to find which of the
> 1,082 numbers on the list net to X. The possible number of combinations
> is staggering (I think it would be 1082 to the second power + 1082 to
> the third power + etc ...all the way to + 1082 to the 1082th power
> number of combinations) so you could see why I'd want the computer to
> do it for me.
>
> Is there a function where I can have excel search for any combination
> of numbers within the 1,082 that net to X? Know what I mean? It could
> be two numbers or it could be 1,000. I have no way of telling.
> Somewhere in this list of numbers are some amount of numbers that net
> to X.
>
>
> --
> bigstevec
> ------------------------------------------------------------------------
> bigstevec's Profile:
http://www.excelforum.com/member.php...o&userid=24749
> View this thread: http://www.excelforum.com/showthread...hreadid=383161
>

[RagDyeR]

See if this old post of Ken Wright's can help:


http://tinyurl.com/a82os
--


HTH,


RD
==============================*================
Please keep all correspondence within the Group, so all may benefit!
==============================*================

"bigstevec" <[email protected]> wrote
in message news:[email protected]...

I really hope someone can help me. I'm using Excel 2002 SP3

I have a column of numbers, 1082 of them in total. I know that some of
the numbers on the list net to a certain number, say "X". I don't know
which of the numbers or even how many of the numbers but, because of
other info I have, SOME of the numbers on the list MUST net to X. In
order to resolve the issue I'm working on, I have to find which of the
1,082 numbers on the list net to X. The possible number of combinations
is staggering (I think it would be 1082 to the second power + 1082 to
the third power + etc ...all the way to + 1082 to the 1082th power
number of combinations) so you could see why I'd want the computer to
do it for me.

Is there a function where I can have excel search for any combination
of numbers within the 1,082 that net to X? Know what I mean? It could
be two numbers or it could be 1,000. I have no way of telling.
Somewhere in this list of numbers are some amount of numbers that net
to X.


--
bigstevec
------------------------------------------------------------------------
bigstevec's Profile:
http://www.excelforum.com/member.php...o&userid=24749
View this thread: http://www.excelforum.com/showthread...hreadid=383161

[Bernie Deitrick]

You cannot solve this problem using Excel - it is simply too big for Excel, and probably for a
single computer.

HTH,
Bernie
MS Excel MVP


"bigstevec" <[email protected]> wrote in message
news:[email protected]...
>
> I really hope someone can help me. I'm using Excel 2002 SP3
>
> I have a column of numbers, 1082 of them in total. I know that some of
> the numbers on the list net to a certain number, say "X". I don't know
> which of the numbers or even how many of the numbers but, because of
> other info I have, SOME of the numbers on the list MUST net to X. In
> order to resolve the issue I'm working on, I have to find which of the
> 1,082 numbers on the list net to X. The possible number of combinations
> is staggering (I think it would be 1082 to the second power + 1082 to
> the third power + etc ...all the way to + 1082 to the 1082th power
> number of combinations) so you could see why I'd want the computer to
> do it for me.
>
> Is there a function where I can have excel search for any combination
> of numbers within the 1,082 that net to X? Know what I mean? It could
> be two numbers or it could be 1,000. I have no way of telling.
> Somewhere in this list of numbers are some amount of numbers that net
> to X.
>
>
> --
> bigstevec
> ------------------------------------------------------------------------
> bigstevec's Profile: http://www.excelforum.com/member.php...o&userid=24749
> View this thread: http://www.excelforum.com/showthread...hreadid=383161
>