Hello,
I am hoping someone can assist me with figuring out a formula that can add a flag in a "NoMatch" type column as displayed below based on a similar set of data. The purpose is to identify where a particular ID has a debit without a matching credit. I assume the fact that the ID can be used more than twice makes this even more complicated but I am hoping someone has encountered a problem like this before. Thank you in advance for any assistance you can provide.
<tbody>
</tbody>
I am hoping someone can assist me with figuring out a formula that can add a flag in a "NoMatch" type column as displayed below based on a similar set of data. The purpose is to identify where a particular ID has a debit without a matching credit. I assume the fact that the ID can be used more than twice makes this even more complicated but I am hoping someone has encountered a problem like this before. Thank you in advance for any assistance you can provide.
ID | Debit | Credit | NoMatch |
1234 | 25 | ||
1234 | 25 | ||
1234 | 25 | X | |
1235 | 100 | ||
1235 | 100 | ||
1236 | 75 | X | |
1237 | 65 | X |
<tbody>
</tbody>