Finding number combinations that equals to a specific amount.

[jigger87]

Hi Excel Experts,

Its been days and I still can't find the answer to my problem. I tried many different approach but nothing is working for me.

I have 2 columns with amounts. Let say these are invoices amount, and we have a 2 reports using to compare if they're equal.
These columns is suppose to be equals but unfortunately there is a difference. The discrepancy is 597.27.
Both columns has 4k+ counts. I tried using the add-in Solver of Excel but it can't process it because of high number of counts.

I'd like to find those invoices that has a total of 597.27 which is the discrepancy in one column. 

Any help would be much appreciated.

I can upload the file if anyone needs it.

[#2]

If the Invoice Amounts are in Columns A and B, and Row 1 are your Column Labels, you can use this formula in C2, copied down rows:
=A2-B2
Any row under Column C that returns an amount other than 0 indicates inequality.

[#3]

Hi @Twifoo,

Thanks for the reply. I already done that. 

I'm trying to look for a numbers combination totaling to a specific amount. 

One of the guides I've found is to solver add-in in excel but this extension can't proceed my columns because I have 4k+ records. 

So I'm looking for alternative way with the same functionality.