Hi,

I have a spreadsheet with 4 columns.

I would like to Compare Column A with Column B, if Column A contains text or numbers anywhere in Column B, then remove the corresponding rows not just in Column B, but Column C and D as well for that row.



Please help.