Problem description:
The following table lists the top 10 products by sales in the first couple of months of the year (the number of months will increase over time):
Solutions:
Use SPL XLL and deal with the following tasks respectively.
- A . Find out the products that make the top 10 in every month of these months:
=spl("=transpose(?1).isect()",B2:E11)
- B . Find out the products that make the top 10 once or more:
=spl("=transpose(?1).union()",B2:E11)
The calculation result is not given here because it is very long.
- C . Find out the products that make the top 10 in January but fail to make the top 10 in any of the other months:
=spl("=transpose(?1).diff()",B2:E11)
Download esProc Desktop for FREE and take your skills to the next level!!! 🚀🔥⬇️
✨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)
Feel free to ask any questions and share your thoughts:
✨Discord
✨Reddit