Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
"Biff" wrote:
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. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OPPOSITE FORMULA
That did it. Again thank you for the knowledge. With the web site I hope to
become more proficient. "Max" wrote: "Biff" wrote: 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. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |