search an array for possibilities
I have a column with totals in it (numbers). From this array of numbers I
want to search for any combination by (adding these numbers together) that
will equal a number in another cell say B3.
Another way to say this is: in Column A I have in each row a number. In
cell B3 I have the number I am looking for, which could be any combination of
adding the numbers from Column A. Is their a way I can search column A and
come up with a combination that will equal what I am searching for in Cell B3?
Column A Column B
1
2
3 26
4
5
6
7
8
9
....
--
Thanks, Kate
|