#111 — Sort in Group
Problem description & analysis: Here below is a data table: Task: Sort the data (in ascending order) by Class and (in descending order) by Score. Solution: Use Excel add-in SPL XLL and enter the following formula: =spl("=E(?1).sort(Class,Maths:-1)",...
Dec 5, 20241 min read3
