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

 

[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!
==============================­================

in message
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.

 

[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