Delete Duplicate entry based on condition

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)

Hi @Sudhir_P ,

if you want to do in superfast mode you have to go for invoke code vb.net code to filter the data greater than zero in the column B and delete the filtered rows in excel to achieve your goal.

Use the below attached code in invoke code activity to achieve the requirement.
Filter and Delete filtered rows VB.net code.txt (706 Bytes)