<h3 id="heading-problem-description-amp-analysis">Problem Description &amp; Analysis:</h3>
We have a statistical table for daily sales of January 2022:
<img src="https://preview.redd.it/search-for-the-position-of-a-certain-value-and-take-values-v0-1ocgy1qil9rd1.png?width=233&amp;format=png&amp;auto=webp&amp;s=1050dfcee5e3a4482a1e5f729dd5407c294a13a8" alt="r/esProc_Desktop - Search for The Position of A Certain Value And Take Values by Position" />
Now we want to find out the day with the largest sales and the sales of 5 days before and after this day.
<h3 id="heading-solution">Solution:</h3>
Enter the following formula in cell C2:
<pre><code class="lang-plaintext">=spl("=E(?1).pmax(Sales)",A1:B32)
</code></pre>
The returned result is 12. Next, find out the sales of 5 days before and after the day with the largest sales:
<pre><code class="lang-plaintext">=spl("=E(?1).to(?2-5,?2+5)",A1:B32,C2)
</code></pre>
As shown in the picture below:
<img src="https://preview.redd.it/search-for-the-position-of-a-certain-value-and-take-values-v0-ctn67tyml9rd1.png?width=246&amp;format=png&amp;auto=webp&amp;s=82f538b8496e0508ca6b65feff2a1e3baa1271f7" alt="r/esProc_Desktop - Search for The Position of A Certain Value And Take Values by Position" />
<hr />
Feel free to download esProc Desktop and let SPL XLL automate this task for you!⬇️
✨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 & Analysis:

We have a statistical table for daily sales of January 2022:

![r/esProc_Desktop - Search for The Position of A Certain Value And Take Values by Position](https://preview.redd.it/search-for-the-position-of-a-certain-value-and-take-values-v0-1ocgy1qil9rd1.png?width=233&format=png&auto=webp&s=1050dfcee5e3a4482a1e5f729dd5407c294a13a8 align="left")

Now we want to find out the day with the largest sales and the sales of 5 days before and after this day.

### Solution:

Enter the following formula in cell C2:

```plaintext
=spl("=E(?1).pmax(Sales)",A1:B32)
```

The returned result is 12.  
Next, find out the sales of 5 days before and after the day with the largest sales:

```plaintext
=spl("=E(?1).to(?2-5,?2+5)",A1:B32,C2)
```

As shown in the picture below:

![r/esProc_Desktop - Search for The Position of A Certain Value And Take Values by Position](https://preview.redd.it/search-for-the-position-of-a-certain-value-and-take-values-v0-ctn67tyml9rd1.png?width=246&format=png&auto=webp&s=82f538b8496e0508ca6b65feff2a1e3baa1271f7 align="left")

---

Feel free to download esProc Desktop and let SPL XLL automate this task for you!⬇️

✨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)

#66 - Search for The Position of A Certain Value And Take Values by Position

Problem Description & Analysis:

Solution: