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

Try:

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" wrote in message
...
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.