First time here? Check out the FAQ!
asked 2012-08-28 01:40:26 +0200Farmer Bob
I am working on an iMac and trying to count the number of 8 digit codes in a column that have a particular letter in the 6th spot with =countif(A1:A10,".C.") but it does not return the correct number. I have also tried ".....C.." and "......C..." and ".*.C.*."
Where A is the searched letter.
You need to enable regular expressions in: Menu/Tools/Options/LibreOffice Calc/Calculate - Enable regular expressions in formulas.
Take a look in the help Index tab for: regular expressions to learn how to use it.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-28 01:40:26 +0200
Seen: 218 times
Last updated: Aug 28 '12