I have three columns : Invoice No, Amount, Payment Type.
I have duplicate Invoice No. and has corresponding one +ve and one -ve value in Amount column.
- First Need to filter Payment Type by L, Y (which always has -ve value in Amt Column)
- Copy row by row relevant Invoice Number:
- Search again in the same excel sheet with invoice number.
- Display with two rows(same invoice number) one has either L or Y which is -ve value and other has diff.payment type but +ve amount value.
- Need to delete the +ve value row???
Attached xaml worked, please feel to modify the workflow.
Demo.xaml (5.7 KB)
Please help.Demo.xlsx (72.9 KB)