[SOLVED]Count numbers that shows up in pairs.

[fivefootnine]

Hi, I need a formula to count how many times a number in a row shows up as a pair (neighbouring cells)
Look at this example

COUNT 2 IN A ROW

4
blank
blank
4
blank
blank
4
4
blank
blank
4
4
blank
RESULT= 2

In this example, the result for count would be 2, as number 4 turns up 2 times in a row 2 times)
The count would NOT include numbers who turns up MORE than TWO times,
I´d have a specific formula for that event.
a formula to COUNT how many times a number turns up THREE times in a row, and a specific formula that counts how many times a number turns up FOUR times in a row and so on....

COUNT 3 IN A ROW

blank
blank
4
4
4
blank
RESULT = 1

In this example, the result for count would be 1, as number 4 turns up 3 times in a row 1 time)

Thanks for any advice and have a nice day!!

[Robert Tucker]

[fivefootnine]

thank you, anyway, this gives me the ERORR:508 message, even when confirmed with ctrl+shift+enter, ?? waht could be causing that?

[Robert Tucker]

Try replacing the commas with semicolons.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

[fivefootnine]

I tried to replace the commas with semicolon and the ERROR message disappeared. Instead the number 14 came up, when I changed the (A1:A13) to (A1:A12) the number 13 came up instead,, confused...

[Robert Tucker]

It works for me:


_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

[fivefootnine]

Thanks, I think I need to download the english version of CALC, I have the swedish version, and I might have translated the code wrong,,, thank you so much!!

[Robert Tucker]

The Swedish is:

[fivefootnine]

Thanks a lot!!
It works now!!
AWESOME!! PROBLEM solved!