How can I have excel search and add multiple cells to find a targe
I am trying to figure out a way to get excel to search and add multiple cells
in different combinations until it finds my target number.
Example. I have 30 cells with varying amounts in them. I know that a
combination of two or more of those cells will equal the number I am
searching for. I want to find a way to have excel sort through the 30 cells,
adding them in different combinations untill it finds the combination(s) of
cells that totals to the number I specify... (like B3,B8,B10=100. Or
20+30+45+5=100)
Does ANYONE have a solution to this... ANY information would be greatly
appreciated!!
|