Problem description:
The following table lists the top 10 products by sales in January and February:
- B
. Find out the products that make the top 10 once or more:
=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)
✨Plugin Installation Method:
✨YouTube FREE courses: SPL Programming
SOCIAL SHARE CARD GENERATOR