Hi all. New to the forum - thanks for existing. Looking forward to sharing my knowledge too.
Now -
I have two individual sheets of 19.000 rows in one column.
Sheet one is ingoing payments. (Positive numbers)
Sheet two is (similar) outgoing payments. (Negative numbers)
The sum of a sheet's rows is ca. 35.000.000 $.
But amongst these 19.000 entries, i have a total imbalance /difference of $ 9.50.
How do I expose the exact imbalance ? Can I match similar +/- numbers and highlight non-matches ? Can I make i separate column where c1=a1+b1 and identify everything that does NOT add up to zero ?
Thanks in advance for any tip.
Now -
I have two individual sheets of 19.000 rows in one column.
Sheet one is ingoing payments. (Positive numbers)
Sheet two is (similar) outgoing payments. (Negative numbers)
The sum of a sheet's rows is ca. 35.000.000 $.
But amongst these 19.000 entries, i have a total imbalance /difference of $ 9.50.
How do I expose the exact imbalance ? Can I match similar +/- numbers and highlight non-matches ? Can I make i separate column where c1=a1+b1 and identify everything that does NOT add up to zero ?
Thanks in advance for any tip.