6.13 Find out interval in which a certain condition occurs continuously
We have a statistical table for daily sales:
Find out the date when the sales rises for three consecutive days or more:
A2: Take A1 as a temporary value. A1 remains unchanged when the sales rises, and plus 1 when the sales falls, and then group according to this temporary value. In this way, the rows of consecutive rise are put into the same group.