Forum Discussion
SUM TO ZERO
Dear Users, I have over 6000 data and i want to Match all amount that sums to zero or a set value without the try and error method which takes time and prone to errors, please how can i achieve t...
thank you very much. Riny_van_Eekelen , suppose i have a distinguish matching details just like @mtarler' have helped asked, how should i go about it? thanks for your contributions.
IDRIS_A Add another helper column adding the attribute/description that pairs matching opposites. Build the pivot table using the 2nd helper column and refresh. Made up some attributes to test it. See attached.