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?
Something like this?
Matching Workbook_2.xlsx
Inveniam Viam Aut Faciam
=COUNTIFS(B:B,-B2,A:A,A2)=0
try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Yes nflsales solution is bettersorry I'm still just a noob in Excel
Hi again guys
Under ETB currency I have a value that is repeated many times. 300 is repeated 3 times and -300 five times and all eight times are considered a match. Is there any way you can make it match with the first positive or negative value it gets. Is it possible to put that in the function? Any recommendation you can give me is greatly appreciated.Sample.xlsx
I did not know how to get this done with a formula, so I tried a VBA solution
Sample_2.xlsm
If you run this macro, make sure you change it to your needs (columns, ranges,....)
There are probably other, better, solutions like last time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks