I have 20k line items on my sheet which I need to match to reconcile my bank. There are multiple amounts of the same value. I need a formula that will create possible matches based on similar amounts that add up to zero (negative and positive)and highlight them. I have seen one thread with conditional formatting, but that didn't generate desired result and slowed down the excel program terribly. The data that needs matching is in column F of the attachment
Regards
Bookmarks