esProc Desktopesproc-desktop.hashnode.dev·Oct 15, 2024#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...excelAdd a thoughtful commentNo comments yetBe the first to start the conversation.
