DEV Community

Cover image for #92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple Sets
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks

Posted on

2 1 1 1 1

#92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple Sets

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):

source table

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)

result 1

  • 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)

result 3


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

Image of Datadog

Master Mobile Monitoring for iOS Apps

Monitor your app’s health with real-time insights into crash-free rates, start times, and more. Optimize performance and prevent user churn by addressing critical issues like app hangs, and ANRs. Learn how to keep your iOS app running smoothly across all devices by downloading this eBook.

Get The eBook

Top comments (1)

Collapse
 
judith677 profile image
Judith-Data-Processing-Hacks

Feel free to ask any questions and share your thoughts:

Discord
Reddit

Image of Docusign

🛠️ Bring your solution into Docusign. Reach over 1.6M customers.

Docusign is now extensible. Overcome challenges with disconnected products and inaccessible data by bringing your solutions into Docusign and publishing to 1.6M customers in the App Center.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay