I have a long list of invoices and credit notes extracted to Excel and I need to be able to exclude postings that match (settles to 0) to only see open postings. Only indicator I have is the amount which of course is one positive and one negative, no other numbers match.
Below there is a screenshot with two rows settling each other marked in red. I would need to find and export these two whole lines into another DT.
Only thing I can think about is a for each row which gets the row item and looks up “matching” values in rest of the DT, but can’t really see how it would work…
Any help is appreciated. Thanks!
Book2.xlsx (11.4 KB)