How do I reconcile data without any unmatched info. In the below, there are 2 items that matched per SWDN (C2 and C3), but the rest are not. I used conditional formatting as example to highlight these two line.
Assuming A2 to E11 are reconciling amounts, how to do automate this without manually figuring out. I have thousands of transactions like this. Thanks in advance for any help.
Recon.JPG
Bookmarks