Thread: Count consecutive repeats
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EV EV is offline
external usenet poster
  
Posts: 2
Default Count consecutive repeats
I'm looking to count the number of consecutive occurances of a 1
without a zero in a table but only if it is a new run. i.e.

Data Result
0 0
1 1
0 0
1 0
1 0
1 3
0 0


A VBA solution is ok

Evan
Australia

Reply With QuoteReply With Quote