Find a composed number out of an array ...

  • Thread starter Thread starter Sige
  • Start date Start date
S

Sige

Hi All,

Imagine I have in Cell B1 a number.

In an array (to be selected) assume Column A filled with a couple
hundred numbers (postive, negative).

Is there a way to verify whether I can re-compose the number in B1 by
ADDING (only!) some of the values in array A?
eg.adding value in A24, A56, A324,...matches exactly value B1!
Highlighting B1 and the corresponding values in the A array when SUM
exactly matched?

All help welcome, Sige
 
Sige,

The answer is no, not without a supercomputer.

HTH,
Bernie
MS Excel MVP
 
Hi Bernie,
I was already afraid so ...
Just hoping that some mad mathematician had already figured out one or
the other ingenius algebraic model / routine.

Cheers, S.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

array formula to extract members of list A that are not in list B 5
Finding a match- should i use a nested array, my source arrays, or 2
Finding a Value Between Two Numbers and Returning Corresponding Value 10
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
Effective Method to Detemine the Beginning and End of An Array? 3
Pulling a currency variable through my arrays drops 3rd decimal? 3
Can I use a UDF in an array formula? 2
Application.Match on 2D array - syntax problem? 9

Back
Top