#74 - Filter by Maximum Or Minimum Value within A Group (Find out One for Each Group)

Problem description & analysis: We have an Excel table for the daily sales of products: Task: Find out products with the largest daily sales and their sales: Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(OrderDate).(~.max...