#75 — Find out The Intervals in Which A Certain Condition Occurs Continuously

#productivity #tutorial #programming #beginners

Problem description & analysis:

We have a statistical table for daily sales:

Task: Find out the date when the sales rises for three consecutive days or more.

Solution:

Use SPL XLL and enter the following code:

    A
1   =0
2   =E(‘A1:B32’).group@o(if(Sales>Sales[-1], A1,A1=A1+1)).select(~.len()>=3).conj()

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.
The results are as follows: