At 20:51 25/10/2008 +0000, Girard Aquino wrote:
I totally had problems with syntax and after reviewing wild
characters, I got it to work with this:
=COUNTIF($Scratch.A2:A123;"\").
Sorry, but - as I said before - you have not begun to explain what
you are doing here. You appear to be counting cells that contain
just a backslash, but you have resisted explaining why. That's
perfectly OK, of course, but it makes it impossible to answer your
questions! In my original example, you would be using something like
COUNTIF(A1:A99;"22008attended") or perhaps COUNTIF(A1:A99;G10), where
G10 contained the relevant string. There were no backslashes there.
But I had to change 1 to 2 for Feb, 3 for March, and so on...
I always thought February *was* the second month! Is it the first
month in your calendar? If not, why are you having to change anything?
is there a simpler or other automated way of doing the formula you
could think of? (just for learning's sake) thank you.
Perhaps something closer to what I suggested. ;^)
At 23:45 25/10/2008 +0000, Girard Aquino wrote:
I've noticed that enabling regular expressions in formulas has to be
ticked every time you run OOo. when you close it, the option is
unticked. is this really the case for that option or a bug in OOo 3.0 on XP?
Neither. I've just checked this on my installation (3.0 on Windows
XP) and that option definitely sticks. It seems to be saved in
documents and perhaps also in the default template, so you should not
see the behaviour your describe.
at first i thought there was something wrong with the formula since
I got zeros on the cells when I opened the file again. one would
think that ticking this option once should do the trick and not have
to do it every time.
It does for me. I cannot guess what you are doing that is different.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
