Rolling Count Formula with Reset

**ctrapper** · 01-05-2011, 03:33 PM

I need some help constructing a formula to help do the follwing:

I have a set of data in Col F:
A
B 1
B 2
B 3
A 1
A 2
B 1
B 2
B 3
B 4
A 1

The numbers are what I am trying to accomplish in Row E. I am basically wanting to a conescutive occurence count.

**Ron Coderre** · 01-05-2011, 03:41 PM

With your posted data in A1:A11

Try this:

Please Login or Register  to view this content.

Copy that formula down through B11

Is that something you can work with?

**DonkeyOte** · 01-05-2011, 03:41 PM

Well assuming 1 appears upon first change

Please Login or Register  to view this content.

**ctrapper** · 01-05-2011, 03:51 PM

YES! That's exactly what I was looking for.. works to perfection.. Thanks a ton!

**Ron Coderre** · 01-05-2011, 04:18 PM

Sometimes I look at what I posted and think: "some idiot logged-in as me and posted a stupid formula."...then I remember...Oh, yeah, that was me :\

**scottylad2** · 01-05-2011, 04:53 PM

B1 1
B1 2
B1 3
A 1 1
A 1 2
B 1 1
B 2 1
B 2 2
B 4 1
A 1 3

=COUNTIF(E$7:E7,E7) and dragged down

**JSmit12** · 10-23-2014, 03:22 AM

Please help my with a calculation

I have 6 columns with weekly kilometer readings (1 - carry over from last month and the the other 5 is the possible weeks per month)

In the seventh column I nee to calculate the kilometers up to date for the month...