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

Judith-Excel-Sharing - Oct 16 - - Dev Community

Problem description & analysis:

We have a statistical table for daily sales:

source table

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()

Enter fullscreen mode Exit fullscreen mode

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:

result table


Download esProc Desktop for FREE and see how it can enhance your workflow!!! 🚀🔥⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .