Hi,

Can you help me with the function or formula to find multiple values and delete them all together. Because right now, I am using Find>Input Value>Find All. I am doing this process one value at a time. Is there a way to input multiple values as per my list?

Or, is there a way that I have list on column A and my “To Find List” on column B, and use this to find and delete all rows with values in column A? Here is what I am planning to do if possible:

Column A
abc.com/conents100
abc.com/contets200
abc.com/contents300
123.com/contentsaaa
123.com/contentsbbb
123.com/contentsccc

Column B (find these values and delete all rows in column A)
abc.com
123.com

Thanks in advance.