Hi!

Check out this book list:

http://contextures.com/xlbooks.html

As for your "opposite" formula:

That looks like one of Max's formulas?

Maybe this:

=IF(O31="","",IF(AND(TRIM(B31)<"Closed",ISNUMBER( SEARCH("Warranty
item",S31))), O31+ROW()/10^10,""))

Biff

"roy.okinawa" wrote in message
...
I was provided this formula to not look for the word Repair Clin:

=IF(O31="","",IF(AND(TRIM(B31)<"Closed",NOT(ISNUM BER(SEARCH("Repair
Clin",S31)))), O31+ROW()/10^10,""))

Now, I need the opposite. I want it to look for the word Warranty item.

Also, can anyone recommend a good Excel book.

Thanks