Hi everyone,
It's part of my job to reconciliate large lists of transactions. I can't attach an example, but I think you guys will get the idea.
I want to automate it as much as possible.
I've found many "problems":
- Company names can be different
- Dates can be different
- 1 transaction can be the SUM of multiple transactions
- Values may be different by cents
- There are duplicates,triplicates,etc.
My way to do this task at the moment is to use a COUNTIF formula, but it's not accurate. Because I may have duplicates or different decimal values (Ex: 10.25 vs 10.23)
Sorry for my spelling mistakes, English is not my native language.
Thanks!!!
Bookmarks