Problem description:

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

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)

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

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

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

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

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