How to remove a row based on Positive value in a column

I have three columns : Invoice No, Amount, Payment Type.
I have duplicate Invoice No. and corresponding +ve and -ve value in Amount column.
First Need to filter Payment Type: L, Y (which has -ve value): Used Filter Data Table
Copy the Invoice Number:
Filter again, based on Invoice Number,
Displayed with two columns with of Invoice Number.
Need to delete the Postive (Amount column)row ?
Please help.Demo.xlsx (72.9 KB)

Hi @Sudhir_P

Please check the sample xaml and hope it will help you. (79.6 KB)


thanks for trying, i don’t think i’m clear enough.
Please check this post, i have modified my question.