Hi Everyone
I'm in need of a function that can match debits and credits of different currencies. I want to match a positive and negative numbers and identify the values without a match.
So far I have come up with =COUNTIF(B:B,-B2)=0. But it doesn't consider the currency column and the fact that there may be more than one value of the same value.
Can anyone help?
Bookmarks