Reputation: 1
The credit and debit values have to be tallied. For example, cell C4 has -1 as value. We need to look for +1 value in column C where column D value should not be Credit or Debit. Once we find that, the value in column D should be changed to Debit.
Here, in this case, C4 will have to find C3 and change value of D3 to Debit.
Upvotes: 0
Views: 25