Vba to find combinations of numbers that equal a given number

[FGaxha]

Hi,
Pls some help:
I need a vba code for: find combination of numbers that equal a given number?
It can be a formula too!
Thanks

 

[rachel06]

Could you just use an IF formula? Like =(IF(A1+B1+C1=10,"Yes","No"))

 

[FGaxha]

Sorry,
It Doesn’t work

 

[Joe4]

Excel already has a solution for that called Solver.
See here for details: Find all combinations of numbers that equal a given sum in Excel

 

[FGaxha]

I tried it but it keeps running for an hr and no solution. Are 54 rows and value given nr 365342.33

 

[Joe4]

Did you try the VBA options further down that page?

 

[Cubist]

There are many threads on this topic. See:

Find the cells contain value sum up to a target value

My work is still using MS2016, and the Solver is disabled. I need to find the transactions that sum up to a targeted value. For instance: Col A has following amount, and the target amount is 90.23 15.23 50.00 566.45 74.20 13.45 45.00 66.78 0.23

www.mrexcel.com