OPPOSITE FORMULA

[roy.okinawa]

I was provided this formula to not look for the word Repair Clin:

=IF(O31="","",IF(AND(TRIM(B31)<>"Closed",NOT(ISNUMBER(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

 

[Max]

... need the opposite. want to look for the word Warranty item.

Try:

Also, can anyone recommend a good Excel book.

Try browsing the comprehensive list in Debra's page at:
http://www.contextures.com/xlbooks.html

 

[Biff]

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

 

[Max]

That looks like one of Max's formulas?

It is <g>. Had quite a long discussion
with the OP, Roy, over the past couple of days.

 

[roy.okinawa]

Max,

I thank you again for the formula and the website. One last one and I think
the worksheet/book will be complete:

Using the same criteria, delete column B from the equation.

 

[Max]

Using the same criteria, delete column B from the equation.

Try:

=IF(O31="","",IF(ISNUMBER(SEARCH("Warranty item",S31)),O31+ROW()/10^10,""))

 

[roy.okinawa]

That did it. Again thank you for the knowledge. With the web site I hope to
become more proficient.