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
Is this what you are looking for:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks