Forum Discussion
Debits and Credits in the same column-excel spreadsheet
I have an excel spreadsheet that has both debits and credits in the same column. I need to identify the matching debit to credit entries. There are a lot of entries and I need the most efficient way to identify. Suggestions please
Thanks
dkawaja
3 Replies
No formulas, I tried to attach a copy of the spreadsheet that maybe helpful. The totals in column J consists of both charges and payments. I am trying to match the equal amounts so that I can determine any discrepancies. Looking for the most efficient way. Any suggestions would be appreciated
- If possible upload your excel file,others can write formulars or codes according to specific problem.
