Anyone know how I can quickly hide/remove all rows in sheet1 that contain any of the rows info from sheet2? It would need to use contains filter as it wouldn't be an exact match.
Sheet1: Column C
http://www.google.com/something/else
http://www.yahoo.com/whatever
www.microsoft.com/hahha
Sheet2: Column A (only column in the sheet)
google.com
So the end result would be the first line in sheet1 would be hidden. Of course I'm working with thousands of rows in sheet1 and like 700 in sheet2.
I've tried MATCH and COUNTIF formulas but I can never get it work right.
Thanks for any help.
EDIT: BTW I'm trying to do this on Excel 2011 for Mac.
Bookmarks