Remove Excel Rows That contain words like

Help
1

Hi,
Any idea how I can modify the list in the For Each to use “Like” instead of specific keywords in the above exercise? At the moment it will only remove rows that match the value defined in the variable.

I would like to modify it to remove rows that have words like “Seller” for example in Private Seller, Public Seller

Thanks.

2

@Supernova

Try like this:

dataTableName.select(“ColumnName Not Like ‘%Seller%’”).CopyToDataTable

It will give you all rows except the column which doesn’t contain ‘Seller’ word.

3

Thanks but not sure that would work in this workflow.

RemoveRowsExcel.zip (11.6 KB)