I need to count consecutive days and output the no.of.days in separate column. I've attached a screenshot
@Ronal_bal Just adjusted it so on X-value = 0 then put 0:
Hey @Ronal_bal,
Think all you need is a multi row formula. Should the 3 row of your expected output not be 1 rather then 0?
So, whenever the value in column X-vales is zero. days should be counted as zero. its like carrying some stuff with you and counting the no of consecutive days it was with you. And then starting again from zero
@Ronal_bal Here is how I would achieve this:
Any questions or issues please ask HTH!Ira
@Ronal_bal can you give an example data set which isn't working? The first X value in your example isn't 0 and it seems fine:
Sorry, my bad. Got it
