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" wrote:
... need the opposite. want to look for the word Warranty item.
Try:
=IF(O31="","",IF(AND(TRIM(B31)<"Closed",ISNUMBER( SEARCH("Warranty
item",S31))),O31+ROW()/10^10,""))
Also, can anyone recommend a good Excel book.
Try browsing the comprehensive list in Debra's page at:
http://www.contextures.com/xlbooks.html
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"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