Forum Discussion

jigger87's avatar
jigger87
Copper Contributor
Apr 26, 2019

Finding number combinations that equals to a specific amount.

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.

 

excel

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 26, 2019
    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.
    • jigger87's avatar
      jigger87
      Copper Contributor
      Apr 26, 2019

      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.