#67 — Search for Row Numbers That Satisfy The Condition

esProc DesktopesProc Desktop
1 min read

Problem description & analysis:

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

Task: Find out the dates with daily sales greater than 1,000.

Solution:

Enter the following code in SPL:

=spl("=E(?1).pselect@a(Sales>1000)",A1:B32)

pselect@a()means returning the sequence number of all rows that meet the condition, and pselect() means returning only the sequence number of the first row that meets the condition. 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

0
Subscribe to my newsletter

Read articles from esProc Desktop directly inside your inbox. Subscribe to the newsletter, and don't miss out.

excel#Excel-tutorialexcel sheetsspreadsheetsVBAlearn codingProgramming BlogsProductivityProgramming TipsPowerBIData Sciencedataanalytics#datamanagement

Written by

esProc Desktop
esProc Desktop

esProc Desktop is a desktop data processing & analytics tool and is specifically designed for ordinary business people. It supports complex computations & spreadsheet data manipulation, can deal with tasks that are hard to accomplish in Excel, and in addition, generates more concise code than VBA and Python. esProc Desktop boasts all-around programming capabilities, supports multi-step interactive data analytics and is easy to use without configurations. This significantly lowers the technical threshold for data analytics.