Thread: Counting Consecutive Periods In Rows Using Numbers
View Single Post
 
Old 03-23-2017, 07:31 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Then why not

Consecutive 2 days: C2+D2 and J2+K2
Consecutive 3 days: J2+L2+L2

And in light of the fact that you have 500000 rows I am also doubtful that Excel is the right tool. Even if Excel has more than a milion rows this is more kind of marketing hype than it is an actual reflection of what Excel is capable to work with.

I regret, but I don't think I am able to help here.
Reply With Quote