Count Consecutive #'s

**ctrapper** · 03-12-2010, 09:40 AM

Hello.. I am doing some statistical analysis, and need some help:
I have a spreadsheet containing 30 columns filled with numbers. I am wanting to count the # of times the #1 appears consecutively. For Example:

Col A
4
5
1
1= 2 Times
3
4
4
3
1= 1
2
1
1
1
1
1= 5

I have done this before, but it was for Alphas, not numerics, and can't figure out the formula edit to make it happen for numerics

**ctrapper** · 03-12-2010, 09:41 AM

Note: I'll have to do this for Columns A through AB... I am assuming I will just edit the range in the formula

**rwgrietveld** · 03-12-2010, 09:51 AM

What is required is a criterium for which rows the subtotal should be given.
Now it is for the 4th, 5th, 6th row (or 4th,9th,15th).

What is that criterium?

**ctrapper** · 03-12-2010, 09:54 AM

I'm sorry.. I am not following the question... Each column contains 50 rows of data.. does that help?

**Palmetto** · 03-12-2010, 09:58 AM

I have done this before, but it was for Alphas, not numerics, and can't figure out the formula edit to make it happen for numerics

Why not post this formula and see if someone can modify it for this situation?

**ctrapper** · 03-12-2010, 10:02 AM

oh you know what, I found what had to be changed! Thanks!

**Palmetto** · 03-12-2010, 10:16 AM

Great. Post your solution so others may benefit. Thanks!

**6StringJazzer** · 03-12-2010, 10:17 AM

Originally Posted by ctrapper

oh you know what, I found what had to be changed! Thanks!

Someday someone will have the same problem and do a search on "Count Consecutive #'s" and find this thread, eagerly reading to find the solution, then...nothing.