At 10:43 21/02/2013 -0800, Joel Madero wrote:
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).
Er, that's 2, 3, 6, and 7.
The solution that was provided to me before was:
=NOT(ISERROR(TEXT("regression",A2)))
Close but no cigar! What I suggested at the time (8 February) was
=NOT(ISERROR(FIND("regression";A2)))
for B2 and fill down the column.
I trust this helps (again).
Brian Barker
--
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
