I have three columns : Invoice No, Amt, Payment Type.
Some Invoice No. has two entry with same invoice number : +ve and -ve in Amount type.
Payment Type(L& Y) has -ve entry and remaining are +ve.
Now, i want to get Invoice Number from Payment L & Y and search in all Payment Type and delete entire row which has +ve value in Amount.
I can do it but takes row by row which takes long time, any short cut please.
refer to xaml file.
Main.xaml (22.3 KB)
Demo.xlsx (10.8 KB)