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 XLL:

=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 boost your Excel skills 🔥⬇️

✨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