Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|