8.1 Intersection, union and difference in the case of simple members - two sets

 

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

imagepng

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

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

imagepng

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

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

imagepng

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)

imagepng

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)

imagepng