Ah, thank you both again....hopefully this is the last time ;) Best, Joel
On Thu, Feb 21, 2013 at 12:13 PM, Alan Boba <[email protected]> wrote: > On Thu, Feb 21, 2013 at 1:43 PM, Joel Madero <[email protected]> > wrote: > > > What I have: > > > > A|B > > comment|regression check > > regression| > > regression,BSA,i10n| > > BLANK| > > BLANK| > > regression| > > regression,bibisected| > > BSA| > > BSA| > > cleanup0407| > > > > If that's not clear those are A1:B10, where | splits A and B columns. B > > column is empty other than B1 which has header "regression check" > > > > I need a formula which will be true if the word "regression" is in A at > all > > (so in the above example A2, A3,A5,A6 would all be true). > > > > If I'm understanding what you want I think this function will give the > results you're looking for > =NOT(ISERROR( SEARCH("regression",A2))) > > SEARCH() is case insensitive so finds the word no matter the capitalization > ISERROR() accounts for empty cells and cells with numbers that cause > SEARCH() to fail > NOT() causes the result to be TRUE when ISERROR() returns FALSE because the > nested SEARCH() is TRUE > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- *Joel Madero* LibreOffice QA Volunteer [email protected] -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
