Deleting rows containing a variable value

[dode74]

Hi

I'm trying to delete rows in a list where the value in column C does not equal a user input value from another table. This is what I have:

Please Login or Register  to view this content.

The input value is s, so I should be left with all rows where column C contains the value s, but what I get is the first 22 rows of the list. Any ideas?

[dode74]

Well a bit of tinkering sorted it. I wasn't actually selecting the row to be deleted, so I added that in:

Please Login or Register  to view this content.

I also needed to reduce the minimum r value to 1 so that it processed the second row.