Hi,

Suppose you want to exclude all rows which contain the word Good. Assume
your data is in range A5:O54004. In A4:O4, type in the headings. In A2,
type =COUNTIF(A5:O5,"*Good*")=0.

Now go to Filter Advanced Filter Copy to another location. In the List
range box, refer A5:O54004, in the criteria box, refer A1:A2. In the copy
to box, give the reference of any blank cell on the same sheet.

Now click on OK.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"waggett" wrote in message
...
Hi Guru's, I need help.

I have a spreadsheet with 12 columns and 54,000 rows. Some of those rows
have a specific word within a cell, and sometimes that word occurs in more
than one cell within the row.

I would like to delete all rows which do not have that word in them,
leaving
only the rows I care about. What is the best way to do this?