Excel formula writing
Budget: $15 – $25 USD
We have 2 reports one from the payment provider and one from the in house system we need to match and find differences. The only unique identifier is the amount.
I need a formula that will match them off and highlight transactions missing.
So I can dump the 2 reports in daily and it spits out the difference on a summary tab.
Would be best if can be done without VBA if possible.
Each report is only about 100 lines per day
I need a formula that will match them off and highlight transactions missing.
So I can dump the 2 reports in daily and it spits out the difference on a summary tab.
Would be best if can be done without VBA if possible.
Each report is only about 100 lines per day