<h3 id="heading-problem-description">Problem description:</h3>
The following table lists the top 10 products by sales in the first couple of months of the year (the number of months will increase over time):
<img src="https://miro.medium.com/v2/resize:fit:1400/0*5-0yv9VNIli6khnK.png" alt />
<h3 id="heading-solutions">Solutions:</h3>
Use SPL XLL and deal with the following tasks respectively.
A. Find out the products that make the top 10 in every month of these months:
<pre><code class="lang-plaintext">=spl("=transpose(?1).isect()",B2:E11)
</code></pre>
<img src="https://miro.medium.com/v2/resize:fit:848/0*9qtyYJKFnyxQ5k9c.png" alt />
B. Find out the products that make the top 10 once or more:
<pre><code class="lang-plaintext">=spl("=transpose(?1).union()",B2:E11)
</code></pre>
The calculation result is not given here because it is very long.
C. Find out the products that make the top 10 in January but fail to make the top 10 in any of the other months:
<pre><code class="lang-plaintext">=spl("=transpose(?1).diff()",B2:E11)
</code></pre>
<img src="https://miro.medium.com/v2/resize:fit:1400/1*-4yPSkm6pcl9cLc3py6waQ.png" alt />
<hr />
Download esProc Desktop for FREE and streamline your workflows in no time!!! 🚀🔥⬇️
✨SPL download address: <a target="_blank" href="http://www.scudata.com/download-Desktop">esProc Desktop FREE Download</a>
✨Plugin Installation Method: <a target="_blank" href="https://c.scudata.com/article/1652061135502">SPL XLL Installation and Configuration</a>
✨References to other rich Excel operation cases: <a target="_blank" href="https://www.scudata.com/html/Desktop-and-Excel-Data-Processing-Cases.html">Desktop and Excel Data Processing Cases</a>
✨YouTube FREE courses: <a target="_blank" href="https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso">SPL Programming</a>

### Problem **description:**

The following table lists the top 10 products by sales in the first couple of months of the year (the number of months will increase over time):

![](https://miro.medium.com/v2/resize:fit:1400/0*5-0yv9VNIli6khnK.png align="left")

### Solutions:

Use **SPL XLL** and deal with the following tasks respectively.

**A**. Find out the products that make the top 10 in every month of these months:

```plaintext
=spl("=transpose(?1).isect()",B2:E11)
```

![](https://miro.medium.com/v2/resize:fit:848/0*9qtyYJKFnyxQ5k9c.png align="left")

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

```plaintext
=spl("=transpose(?1).union()",B2:E11)
```

The calculation result is not given here because it is very long.

**C**. Find out the products that make the top 10 in January but fail to make the top 10 in any of the other months:

```plaintext
=spl("=transpose(?1).diff()",B2:E11)
```

![](https://miro.medium.com/v2/resize:fit:1400/1*-4yPSkm6pcl9cLc3py6waQ.png align="left")

---

Download esProc Desktop for FREE and streamline your workflows in no time!!! 🚀🔥⬇️

✨SPL download address: [esProc Desktop FREE Download](http://www.scudata.com/download-Desktop)

✨Plugin Installation Method: [SPL XLL Installation and Configuration](https://c.scudata.com/article/1652061135502)

✨References to other rich Excel operation cases: [Desktop and Excel Data Processing Cases](https://www.scudata.com/html/Desktop-and-Excel-Data-Processing-Cases.html)

✨YouTube FREE courses: [SPL Programming](https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso)

#92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple Sets

Problem description:

Solutions: