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

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

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

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

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

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)

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)

esProc Desktop and Excel Processing
7.15 Generate number in each group
8.2 Intersection, union and difference in the case of simple members - multiple sets