Problem description & analysis:
There is a statistical table for daily sales:
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)
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:
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
Top comments (1)
Do not hesitate to share your thoughts with other Excel enthusiasts!
✨Discord
✨Reddit