Combination of sum macro?

[calvinle]

Hi,

Every year, I need to consolidate several amount and make sure which of them falls into a sum of an amount.
I wonder if excel can find all the calculation in range A, and highlight those that equal to the cell D10 (example as per my attachment).

Please if anyone can help with this.

Thanks.Calculation.xlsx

[alansidman]

Here is a tutorial to help you.

http://www.get-digital-help.com/2010...lver-in-excel/

[calvinle]

Yes, but this option is taking too long if my data is over 20 cells..? Any other alternative option?

[alansidman]

I ran it in the example you provided and it took about 15 seconds. Seems a lot quicker than doing it manually.

[calvinle]

Did you? Because I ran it too, however, it doesnt give me the right solution tho..

[alansidman]

Here is a picture of the results I got and a possible explanation of why it was not able to supply an explanation. Have you been able to solve it manually?