Forum Discussion
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 invo...
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.
=A2-B2
Any row under Column C that returns an amount other than 0 indicates inequality.
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.
