I have to remove entire row based on some condition (below):
1.Cell in Credit column is empty
2.Transaction Description 1 column containing “SWEEP TRANSACTION”
3.Transaction Description 2 column containing “Amazing” as partial cell value
i have attached the excel file .“Sheet1” - input
and “Sheet2” - output.
Can someone please help me … I have tried different ways but didn’t get success in last 3-4 days.
AhteshamSample data.xlsx (11.1 KB)