Greetings everyone,
After scouring the internet for days now, and unable to find a solution to fit my needs, I present this question to you wise souls.
If a solution already exists on this forum, then please accept my sincerest apologies for reposting, as I was unable to find it using the search function. Majority of the solutions posted are either single column reconciliations, and/or have a unique key/identifier, both of which are not the available with my data.
I would really appreciate any guidance or help, either in the form of VBA, formulas, or conditional formatting
My data is as below:
<tbody>
</tbody>
Salient features of the data are as follows:
Technicalities of the problem are as below:
Based on the above, I was hoping if the solution could highlight the reconciling items on a cell level only, and/or delete the matching items on a cell level.
I hope that above would wet someones appetite for puzzle solving, which the rest of us could learn from.
Thanks,
After scouring the internet for days now, and unable to find a solution to fit my needs, I present this question to you wise souls.
If a solution already exists on this forum, then please accept my sincerest apologies for reposting, as I was unable to find it using the search function. Majority of the solutions posted are either single column reconciliations, and/or have a unique key/identifier, both of which are not the available with my data.
I would really appreciate any guidance or help, either in the form of VBA, formulas, or conditional formatting
My data is as below:
DEBIT | CREDIT |
100 | -50 |
584 | -4 |
94 | -4899 |
150 | 100 |
4899 | -54 |
-11 | -358 |
-358 | -100 |
20 | -100 |
20 | 50 |
<tbody>
</tbody>
Salient features of the data are as follows:
- The ordering of numbers in both the columns are mixed, they are neither ascending nor descending
- There is no "key"or unique identifier which links the 2 columns.
- The negative signs in the debit column, and the positive signs in the credit column are not mistakes, they are there on purpose.
Technicalities of the problem are as below:
- If Debit + Credit = Debit, in this case the original debit becomes a reconciling item.
- If Debit + Credit = Credit, in this case, the original credit becomes a reconciling item.
- If Debit + Credit = 0, in this case, both the debit and credit entries are matched should be eliminated or deleted.
- Please consider the above data to be present in the columns W and X in excel, with data present (several columns deep) on either sides of column W and column X
Based on the above, I was hoping if the solution could highlight the reconciling items on a cell level only, and/or delete the matching items on a cell level.
I hope that above would wet someones appetite for puzzle solving, which the rest of us could learn from.
Thanks,