How to filter a column in an excel sheet based on the value of an another column

I have tried to filter a column in an excel sheet which has the value “Fail” in its corresponding another column, but i am not able to figure out what command i need to give in the assign activity. Can anyone help me out with this??
Thanks in advance :slight_smile:

Main2.xaml (9.1 KB)
Excel.xlsx (9.3 KB)

@im_heathen try below workflow. I have edited your workflow. Change path in excel application scope.

Main2Edited.xaml (9.2 KB)

Bro only the URLs must be written into the sheet not the response and status column too, also it seems to add the columns i want to delete all the data moved in the sheet and write this data into the sheet. how to do that??

@im_heathen i did get you. What output you exactly needed. Please be clear about your output.

Desired O/P

Ex.xlsx (8.4 KB)

@im_heathen try below code. i have edited you code

Main2.xaml (9.2 KB)

Yeah, it works. Thank you :slight_smile: