I am trying to find an easier way to match a bank statement with a general ledger detail report in order to make sure that the checks balance and clear. Basically I could put information on 1 sheet like the following:
Column A and B are from bank Statement
Col A = Check Number
Col B = Check Amount
Column C and D are from General ledger
Col C = Check Number
Col D = Check Amount
I would like to make it so that they would match side by side and if they did not it would leave a blank space next to it. I am a little familiar with ecel but this formula is a little above my head. Any help would be appreciated.
Thanks
Bookmarks