At 15:45 11/03/2017 +0000, 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 with a letter) eg X1
Aa12 D7a etc.
I want to obtain a regular expression for COUNTIF that will enable
me to find out how many times a particular code, contained in
another cell, occurs in the column. I was thinking that \b to detect
the word boundaries should help but i cant quite get it to work; im
not sure if this is because it is assuming a word boundary between
the letter and the number or if it is simply my incompetence as
usual. Does anyone have an idea what may be the best way to achieve this?
Try
=COUNTIF(range;"\b"&Xn&"\b")
- where "range" represents the column of data and Xn represents the
cell containing the code to be counted. Remember that you need to
have Tools | Options... | LibreOffice Calc | Calculate | Enable
regular expressions in formulae ticked (which is the case by default).
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
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
