#63 — Search for The Nth Value And The Nth Value from Last

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

Problem description & analysis:

Here below is a sales statistical table:

Task: Now we want to find out the product ranked tenth by sales and its sales, and the product ranked tenth from last by sales and its sales.

Solution:

Enter the following formulas in SPL XLL. The results are as follows:
The 10th:
=spl("=E(?1).sort(ProductSales:-1)(10)",A1:C78)

The 10th from last:
=spl("=E(?1).sort(ProductSales:-1).m(-10)",A1:C78)

ℹ️ Feel free to download esProc Desktop and explore the related information:
SPL download address: esProc Desktop 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-24T03:10:04+00:00) #63 — Search for The Nth Value And The Nth Value from Last. Retrieved from https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/

MLA

" » #63 — Search for The Nth Value And The Nth Value from Last." Judith-Excel-Sharing | Sciencx - Tuesday September 24, 2024, https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/

HARVARD

Judith-Excel-Sharing | Sciencx Tuesday September 24, 2024 » #63 — Search for The Nth Value And The Nth Value from Last., viewed ,<https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/>

VANCOUVER

Judith-Excel-Sharing | Sciencx - » #63 — Search for The Nth Value And The Nth Value from Last. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/

CHICAGO

" » #63 — Search for The Nth Value And The Nth Value from Last." Judith-Excel-Sharing | Sciencx - Accessed . https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/

IEEE

" » #63 — Search for The Nth Value And The Nth Value from Last." Judith-Excel-Sharing | Sciencx [Online]. Available: https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/. [Accessed: ]

rf:citation

» #63 — Search for The Nth Value And The Nth Value from Last | Judith-Excel-Sharing | Sciencx | https://www.scien.cx/2024/09/24/63-search-for-the-nth-value-and-the-nth-value-from-last/ |

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.