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
Top comments (1)
Some comments may only be visible to logged-in visitors. Sign in to view all comments.