Problem description &amp; analysis:
We have two rows of numbers:
<table><tbody><tr><td></td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td></tr><tr><td>1</td><td>4211140</td><td>4209106</td><td>4209974</td><td>4211320</td><td>4208228</td><td>4210873</td><td>4211439</td></tr><tr><td>2</td><td>8859990</td><td>8903354</td><td>8900184</td><td>8901922</td><td>8900052</td><td>8903899</td><td></td></tr></tbody></table>

Get two numbers from each row (the two numbers can be the same) and make the sum of the four numbers the fixed value 26216692; put the two numbers obtained from row 1 in column A and column B, and the ones obtained from row 2 in column C and column D, as shown below:
<table><tbody><tr><td></td><td>A</td><td>B</td><td>C</td><td>D</td></tr><tr><td>4</td><td>4208228</td><td>4208228</td><td>8900184</td><td>8900052</td></tr></tbody></table>

Solution:
Use SPL XLL to get this done:
<pre><code class="lang-plaintext">=spl("=g1=E@1(?1),g2=E@1(?2),E@b(xjoin(g1;g1;g2;g2).select(#1+#2+#3+#4==26216692 &amp;&amp; #1&gt;=#2 &amp;&amp; #3&gt;=#4))",A1:G1,A2:F2)
</code></pre>
As shown in the picture below:
<img src="https://cdn-images-1.medium.com/max/1600/0*929jmRwpTfAC1t5G.png" alt />
Explanation:
xjoin function performs cross product. E@1 converts a multilayer sequence to a single-layer one. E@b removes titles, and #1 represents the 1st column of the table.
Want to learn more about the potential of SPL XLL? Here's the information you may need:
SPL download address: <a target="_blank" href="http://www.scudata.com/download-Desktop">esProc Desktop 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="http://c.raqsoft.com/article/1651916536524">Desktop and Excel Data Processing Cases</a>
SPL Programming (YouTube FREE courses): <a target="_blank" href="https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso">https://www.youtube.com/playlist?list=PLQeR-IhHo7qNCw6o7PW8YfHvRx8pgzZso</a>

**Problem description & analysis**:

We have two rows of numbers:

<table><tbody><tr><td colspan="1" rowspan="1"></td><td colspan="1" rowspan="1">A</td><td colspan="1" rowspan="1">B</td><td colspan="1" rowspan="1">C</td><td colspan="1" rowspan="1">D</td><td colspan="1" rowspan="1">E</td><td colspan="1" rowspan="1">F</td><td colspan="1" rowspan="1">G</td></tr><tr><td colspan="1" rowspan="1">1</td><td colspan="1" rowspan="1">4211140</td><td colspan="1" rowspan="1">4209106</td><td colspan="1" rowspan="1">4209974</td><td colspan="1" rowspan="1">4211320</td><td colspan="1" rowspan="1">4208228</td><td colspan="1" rowspan="1">4210873</td><td colspan="1" rowspan="1">4211439</td></tr><tr><td colspan="1" rowspan="1">2</td><td colspan="1" rowspan="1">8859990</td><td colspan="1" rowspan="1">8903354</td><td colspan="1" rowspan="1">8900184</td><td colspan="1" rowspan="1">8901922</td><td colspan="1" rowspan="1">8900052</td><td colspan="1" rowspan="1">8903899</td><td colspan="1" rowspan="1"></td></tr></tbody></table>

Get two numbers from each row (the two numbers can be the same) and make the sum of the four numbers the fixed value 26216692; put the two numbers obtained from row 1 in column A and column B, and the ones obtained from row 2 in column C and column D, as shown below:

<table><tbody><tr><td colspan="1" rowspan="1"></td><td colspan="1" rowspan="1">A</td><td colspan="1" rowspan="1">B</td><td colspan="1" rowspan="1">C</td><td colspan="1" rowspan="1">D</td></tr><tr><td colspan="1" rowspan="1">4</td><td colspan="1" rowspan="1">4208228</td><td colspan="1" rowspan="1">4208228</td><td colspan="1" rowspan="1">8900184</td><td colspan="1" rowspan="1">8900052</td></tr></tbody></table>

**Solution**:

Use ***SPL XLL*** to get this done:

```plaintext
=spl("=g1=E@1(?1),g2=E@1(?2),E@b(xjoin(g1;g1;g2;g2).select(#1+#2+#3+#4==26216692 && #1>=#2 && #3>=#4))",A1:G1,A2:F2)
```

As shown in the picture below:

![](https://cdn-images-1.medium.com/max/1600/0*929jmRwpTfAC1t5G.png align="left")

**Explanation**:

xjoin function performs cross product. E@1 converts a multilayer sequence to a single-layer one. E@b removes titles, and #1 represents the 1st column of the table.

Want to learn more about the potential of SPL XLL? Here's the information you may need:

SPL download address: [esProc Desktop 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](http://c.raqsoft.com/article/1651916536524)

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

	A	B	C	D	E	F	G
1	4211140	4209106	4209974	4211320	4208228	4210873	4211439
2	8859990	8903354	8900184	8901922	8900052	8903899

#26 — Get Two Numbers from Each of The Two Sets of Numbers and Let Them Equal A Specified Value