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

This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Problem Description & Analysis:

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

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 to get the day with the largest sales:
=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:
=spl("=E(?1).to(?2–5,?2+5)",A1:B32,C2)
As shown in the picture below:

Feel free to download esProc Desktop and use this simple SPL formula to save time and get insights in seconds! 🔍💡⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming

This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing

Print Share Comment Cite Upload Translate Updates

APA

Judith-Excel-Sharing | Sciencx (2024-09-27T02:56:48+00:00) #66 — Search for The Position of A Certain Value And Take Values by Position. Retrieved from https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/

MLA

" » #66 — Search for The Position of A Certain Value And Take Values by Position." Judith-Excel-Sharing | Sciencx - Friday September 27, 2024, https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/

HARVARD

Judith-Excel-Sharing | Sciencx Friday September 27, 2024 » #66 — Search for The Position of A Certain Value And Take Values by Position., viewed ,<https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/>

VANCOUVER

Judith-Excel-Sharing | Sciencx - » #66 — Search for The Position of A Certain Value And Take Values by Position. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/

CHICAGO

" » #66 — Search for The Position of A Certain Value And Take Values by Position." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/

IEEE

" » #66 — Search for The Position of A Certain Value And Take Values by Position." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/. [Accessed: ]

rf:citation

» #66 — Search for The Position of A Certain Value And Take Values by Position | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2024/09/27/66-search-for-the-position-of-a-certain-value-and-take-values-by-position/ |

Please log in to upload a file.

There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.