Did the OP get this working.
I have it working with
=COUNTIF(SEARCH("\b"&$G$37&"\b",E37:E39),">1")
$G$37 contains the search term with word boundaries.
E37:E39 is the range I am searching.
Enter into the cell where you want the answer
=COUNTIF(SEARCH("\b"&$G$37&"\b",E37:E39),">1") and press CTL
Hi Regina,
Thank you, yes, that's cracked it. (*so* many pitfalls for the unwary!)
Best
Gary
On Sun, 12/3/17, Regina Henschel wrote:
Subject: Re: [libreoffice-users] regular expression for calc
To: users@global.libreoffice.org
Date: Sunda
If the code you are looking for only occurs once per cell you could use
find() or search() against each cells to determine if the code is present
then countif() the results where greater than zero.
On Sun, Mar 12, 2017 at 1:50 PM, Regina Henschel
wrote:
> Hi Gary,
>
> find the option "Search cri
Hi Gary,
find the option "Search criteria = and <> must apply to whole cells" in
Tools > Options > Calc > Calculate. Try it with disabled option.
Kind regards
Regina
Gary Collins schrieb:
Hi Brian
I wish i could say it did help but unfortunately not. It works with the whole cell contents but
and im using 64bit windows 7.
G.
On Sun, 12/3/17, Brian Barker wrote:
Subject: Re: [libreoffice-users] regular expression for calc
To: users@global.libreoffice.org
Date: Sunday, 12 March, 2017, 5:51
At 15:45 11/03/2017 +, Gary
Collins wrote:
>I have a column each row of which
At 15:45 11/03/2017 +, Gary Collins wrote:
I have a column each row of which contains a sequence of one or more
codes separated by a space. In case it will make a difference each
code consists of a letter (occasionally 2 letters) followed by a
number of up to 3 digits (and occasionally ends
Apologies if this appears twice; im not sure if there was a problem with
sending...
Hello,
I have a column each row of which contains a sequence of one or more codes
separated by a space. In case it will make a difference each code consists of a
letter (ooccasionally 2 letters) followed by a nu
Hello,
I have a column each row of which contains a sequence of one or more codes
separated by a space. In case it will make a difference each code consists of a
letter (ooccasionally 2 letters) followed by a number of up to 3 digits (and
occasionally ends with a letter) eg X1 Aa12 D7a etc.
I