Excel formula writing -- 2
Budget: £20 – £250 GBP
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