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.
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.