View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kate kate is offline
external usenet poster
 
Posts: 112
Default 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