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

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:

---

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

Comments

[Judith-Excel-Sharing]

Have you given it a try yet? We’d love to hear your thoughts!

Discord
Reddit