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":
  1. Company names can be different
  2. Dates can be different
  3. 1 transaction can be the SUM of multiple transactions
  4. Values may be different by cents
  5. 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!!!