Ask Your Question

Farmer Bob's profile - activity

2015-10-17 20:25:42 +0200 received badge  Famous Question (source)
2015-10-17 20:25:42 +0200 received badge  Notable Question (source)
2015-10-17 20:25:42 +0200 received badge  Popular Question (source)
2014-12-23 17:16:47 +0200 received badge  Popular Question (source)
2014-12-23 17:16:47 +0200 received badge  Famous Question (source)
2014-12-23 17:16:47 +0200 received badge  Notable Question (source)
2013-07-25 23:06:44 +0200 received badge  Notable Question (source)
2013-07-25 23:06:44 +0200 received badge  Famous Question (source)
2013-07-25 23:06:44 +0200 received badge  Popular Question (source)
2013-03-03 01:26:05 +0200 received badge  Famous Question (source)
2013-02-19 23:44:31 +0200 received badge  Notable Question (source)
2013-02-19 23:44:31 +0200 received badge  Popular Question (source)
2012-08-30 20:39:32 +0200 asked a question Counting Rows

Hello

I am trying trouble with the ROWS function in LO 3.5.0rc3 on my iMac. If I put the formula =ROWS($A$1:$A1) and copy and past it into cells A2 to A5 I get the following formulas: A2=ROWS($A$2:$A2) result =1 A3=ROWS($A$3:$A3) result =1 A4=ROWS($A$4:$A4) result =1
A5=ROWS($A$5:$A5) result =1

What I would expect and need is: A2=ROWS($A$1:$A2) result =2 A3=ROWS($A$1:$A3) result =3 A4=ROWS($A$1:$A4) result =4
A5=ROWS($A$1:$A5) result =5

For some reason the absolute cell reference to cell $A$1 does not stick. It does not matter which column I try it in. However if I save the file and open it in Open Office I can copy and paste the formula with no trouble, save the file, reopen in LO and it works fine. But that is a pain of a work around.

Any ideas?

Thanks

MRB

2012-08-28 01:40:26 +0200 asked a question Countif for letter in middle of text

Hello

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.*."

Any ideas

Thanks

2012-08-27 19:17:54 +0200 received badge  Scholar (source)
2012-08-24 01:53:56 +0200 asked a question Countif on iMac

I would like to count the number of words in a column that end with a certain letter. Countif works fine for counting how many start with a certain letter but will not work to count words that end or contain a certain letter. For example: COUNTIF(A1:A11,"c.") works fine but COUNTIF(A1:A11,".c") just gives 0.

Any ideas?

Thanks

2012-07-26 17:33:07 +0200 received badge  Student (source)
2012-07-16 18:22:26 +0200 commented answer Countif based on last character in text string

Would any one have a suggestion on a SUMPRODUCT & REPLACE formula that might work? Or a different work around?

2012-07-16 18:20:07 +0200 commented answer Countif based on last character in text string

Thanks, I have also tried a workaround using SUMPRODUCT and REPLACE but still get 0.

2012-07-16 16:34:15 +0200 commented answer Countif based on last character in text string

I have double checked for blank spaces following the last character and also manually entered a sample list on a new sheet and still it returns 0. The same problem exists when I try it with Open Office. I am running OSX Snow Leopard on an iMac.

2012-07-16 03:45:08 +0200 commented question Countif based on last character in text string

Yes, regular expressions are enabled. As a result countit based on the first character works for example =countif(A2:A12,"W.*") returns 1 but countif based on the last character does not.

2012-07-16 00:30:52 +0200 answered a question Countif based on last character in text string

Hello

Thanks but that gives a result of 0.

FB

2012-07-15 23:36:12 +0200 received badge  Editor (source)
2012-07-15 23:27:54 +0200 asked a question Countif based on last character in text string

I have a column of text based codes. Some end with F, some with A and some with - .

A1 KnotsP-A A2 SaucyF-- A3 B-SweP-F A4 StancF-F A5 RoothF-F A6 GrainF-- A7 RavenP-F A8 GermaP-A A9 ParkeF-F A10 LucieFE- A11 Top MPEF A12 WarneF-F

I would like to be able to count how many end with F. I have tried a number of variations suce as: =countif(A1:A12,.f) and =countif(A1:A12,".F") and =countif(A1:A12,"=.F") but they do not work. =countif(A1:A12,"W.") works, returns 1

Please note that the formulae include the wildcard asterix but they don't seem to show up on this blog.

Any help would be great.

Thanks FB