Delete row if one of the specified values are not identified on that row, column A

If you have a large list or dataset and need to keep particular rows of data rather than select those you don’t want you can select the ones you want to keep and use this example below to create a script to remove all but these values specified.

Adjust the code going from the bottom row to the top, and the values of the items you wish to keep. This particular code is taken as an example from a recent project whereby a client who sold thousands of items on Amazon wanted to remove all but specific brands.

Datanology are data experts and can help you accomplish any data project or task. Feel free to contact us using the form or ask a question about this example script.