---
title: "Discussion on \"#111 — Sort in Group\" | Hashnode"
description: "Discussion on \"#111 — Sort in Group\". Problem description & analysis:\nHere below is a data table:\n\nTask: Sort the data (in ascending order) by Class and (in descending order) by Score.\nSolution:\nUse Excel add-in SPL XLL and enter the following formula:\n=spl(\"=E(?1).sort(Class,Maths:-1)\",..."
url: "https://hashnode.com/posts/111-sort-in-group/67510ba449c7216ab44d91ea"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [#111 — Sort in Group](https://esproc-desktop.hashnode.dev/111-sort-in-group?utm_source=hashnode&utm_medium=feed)

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, 2024 · 1 min read · esproc-desktop.hashnode.dev  
Read the article

-   [#excel](https://hashnode.com/tag/excel)
-   [#excel-tutorial](https://hashnode.com/tag/excel-tutorial)
-   [#excel-sheets](https://hashnode.com/tag/excel-sheets)
-   [#sorting](https://hashnode.com/tag/sorting)
-   [#sorting-algorithms](https://hashnode.com/tag/sorting-algorithms)
-   [#sortingtechniques](https://hashnode.com/tag/sortingtechniques)
-   [#databases](https://hashnode.com/tag/databases)
-   [#data-structures](https://hashnode.com/tag/data-structures)
-   [#data-analysis](https://hashnode.com/tag/data-analysis)
-   [#productivity](https://hashnode.com/tag/productivity)
-   [#programming-tips](https://hashnode.com/tag/programming-tips)
-   [#coding](https://hashnode.com/tag/coding)
-   [#codenewbies](https://hashnode.com/tag/codenewbies)

## Written by

[esProc](https://hashnode.com/@esProcDesktop)

@esProcDesktop

  
[View profile](https://hashnode.com/@esProcDesktop)

esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. FREE download👉🏻: https://www.esproc.com/download-esproc

## Responses

Markdown supported · ⌘↵ to post

[esProc](https://hashnode.com/@esProcDesktop)

[Dec 5, 2024](https://hashnode.com/posts/111-sort-in-group/67510ba449c7216ab44d91ea/comment/67510cd32a2ad3ca9554d7b2)

Fast. Accurate. Game-changing. 💡

Learn more about SPL XLL: 👉🏻Discord:[discord.gg/cFTcUNs7](https://discord.gg/cFTcUNs7) 👉🏻Reddit: [reddit.com/r/esProc\_Desktop](https://www.reddit.com/r/esProc_Desktop/)