You could try this:
1.) Use a Read Range only on the filter column (you need that much to know what to delete).
2.) Create a List(Of Int32) to hold row numbers.
3.) Add a For Each Row loop over the data you read from Excel with a variable set for the Row Index. In the loop, if the filter value matches what you want to delete, add the variable for the Row Index to the list.
4.) After the For Each Row loop, add an Excel Applicatoin Scope activity to open the workbook.
5.) Add a For Each activity to iterate over the list you created in the previous steps.
6.) In the loop, use a Delete Row activity (the one for Excel) and use the values in the list to delete each row you’ve identified that should not be in the workbook. You may have to add 2 to the variable, since the row indices start at 0, and you’ll have to account for the fact that Excel starts at A1 and your workbook probably has headers.