Hi ... I have a file with 10 columns. One column (H) have numeric values and one with a reference number(J). I need to identify all the rows that have a common debit(plus) and credit(minus) with the same reference number. U have looked all over the site and can't seem to find what I am looking for. I do this manually every month, but the file just continues to grow with each period, so it is becoming cumbersome.
Hope there is a savior out there for me!
Thanks
Hope there is a savior out there for me!
Thanks