DEV Community

Cover image for #91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets
Judith-Excel-Sharing
Judith-Excel-Sharing

Posted on

#91 — Intersection, Union, And Difference in the Case of Simple Members — Two Sets

Problem description:

The following table lists the top 10 products by sales in January and February:

source table

Solutions:

Use SPL XLL and deal with the following tasks respectively.

  • A . Find out the products that make the top 10 in both January and February:

=spl("=?1^?2",B2:B11,C2:C11)

result 1

  • B . Find out the products that make the top 10 once or more:

=spl("=?1&?2",B2:B11,C2:C11)

result 2

  • C . Find out the products that make the top 10 in January but fail to make the top 10 in February:

=spl("=?1\?2",B2:B11,C2:C11)

result 3

  • D . Find out the products that make the top 10 in February but fail to make the top 10 in January:

=spl("=?2\?1",B2:B11,C2:C11)

result 4


Download esProc Desktop for FREE and streamline your workflows in no time!!! 🚀🔥⬇️

✨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 (0)