#84 — Accumulation for Continuous Occurrence of A Certain Condition

Judith-Excel-Sharing - Oct 29 - - Dev Community

Problem description & analysis:

There is a statistical table for daily sales:

source table

Task: We want to add a column to the right to calculate the cumulative days of consecutive rising (to calculate in cell C1).

Solution:

Use SPL XLL and the code is as follows:

  A
1 =0
2 return E(‘A1:B32’).new(if(Sales>Sales[-1], A1=A1+1,A1=0):RiseDayCount)
Enter fullscreen mode Exit fullscreen mode

A2: Take A1 as a temporary value. A1 plus 1 when the sales volume rises, and assign A1 to 0 when the sales volume falls.

The results are shown below:

result table


Download esProc Desktop for FREE to optimize your data 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

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