Good afternoon!
I have a large amount of data (100K+ rows) where I need to match debits (position amounts) with offsetting credits (negative amounts) based on the the invoice. I have been using this function =ROUND(SUMIFS([AMT],[XREF],[XREF]),2)=0; however, it has not found all offsetting entries and takes forever! I am attaching a file with data, as an example, and would appreciate any help/thoughts to achieve this more quickly or to get a macro to accomplish this task.
Thank you!!!
Bookmarks