#68 — Search for Rows That Satisfy The Condition

Problem description & analysis: We have a statistical table for daily sales of January 2022: Task: Find out the data with daily sales greater than 1,000. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).select(Sales>1000)",A1:B32) T...