Problem description & analysis:
We have an Excel table for the daily sales of products:
Task: We want to find out the date when the total daily sales amount exceeds 300,000.
Solution:
Use SPL XLL and enter the following code:
=spl("=E(?1).groups(OrderDate;sum(Sales):TotalSales).select(TotalSales>300000)",A1:C2401)
The results are as shown below:
Download esProc Desktop for FREE and Boost your Excel productivity with this technique!!! 🚀🔥⬇️
✨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)
Use SPL XLL for seamless data processing and discuss your experiences with the communities!
Discord
Reddit