I have a scenario where in excel, i have 2 columns -account and amount. The amount column has both debit and credit values. I add a new column using abs value of amount and sort data on abs values. Now, I have to match the rows for same account which has same debit and credit value. The issue is th…

Filter excel data based on a matching rule - if col1 value(account) is same and col2(amount) is matching as debit & credit, need to exract the rows

Pablito (Pawel Wozniak) June 6, 2019, 6:47am 2

Hi @ui2507path,
Please have a look here:

You have some topics there which frequently repeats. Think point 4 should help you

1 Like