Hi All,
I've asked this before but can't track down the thread so here it goes
again, the previous solution did not work (thought it had).
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).
The solution that was provided to me before was:
=NOT(ISERROR(TEXT("regression",A2)))
I'm getting inconsistent results with this, I'm not even sure exactly what
it's finding but something isn't right.
Thanks in advance,
Joel
--
*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
