I have a spreadsheet with about 30000 rows in it. One of the columns in the spreadsheet has comments from our employees to document communications with our customers. I need to create a new spreadsheet with all of the columns for all rows where column E contains any of the following: price, cost, margin, percent, match, competitive, quote. I am stumped on how to do this. I basically want to say show me rows that column E contains the word price or cost or margin or percent or match or competitive or quote.
How can I do this?