At 19:52 01/08/2014 +0100, David Eccles wrote:
In Excel it was easy. I simply specified =COUNTIF(G8:X8;"*c*") and I got the number of cells that contained the letter c. I discovered in LibreOffice it was =COUNTIF(G8:X8;".*c.*") but in Openoffice whatever combination I try doesn't work.
That should work in OpenOffice. Go to Tools | Options... | OpenOffice Calc | Calculate and ensure that "Enable regular expressions in formulae" is ticked. (That's in Preferences under Mac OS.)
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
