Delete Row if value not equal to "x"

[vladuz976]

I am trying to delete all columns in a sheet except for the ones I am interested in.
The list is much longer than the example below.

What would be the best way to do this?
a long IF NOT OR statement or can I put them into an array or list and somehow say if cell value not in array, then delete?

Please Login or Register  to view this content.

[mmmarks]

try dis one,

Please Login or Register  to view this content.

[Steffen Thomsen]

You could do it like this

Please Login or Register  to view this content.

[vladuz976]

That worked! Thanks

try dis one,

Please Login or Register  to view this content.

[vladuz976]

Sorry, if this is an obvious question, but what datatype is
"items_to_exclude" here?

You could do it like this

Please Login or Register  to view this content.

[Steffen Thomsen]

Thats just a comma delimitered string easier to maintain than rewriting an if statement.