Forum Discussion
Solved
Sorting a table with groups of people (no VBA)
Hi, I have a table with groups of people in a team. The individual team can vary from 3 to 4 persons. The table list the group and their group score/result (se attached image). How can I sort the t...
If you already have GROUPBY:
=LET( grouped, GROUPBY( Table[Group], Table[Res.], SUM,, 0 ), filled_res, XLOOKUP( Table[Group], CHOOSECOLS( grouped, 1 ), CHOOSECOLS( grouped, 2) ), sorted, SORTBY( Table, filled_res, 1, SEQUENCE( ROWS( Table ) ), 1 ), IF( ISBLANK( sorted ), "", sorted ) )
If you already have GROUPBY:
=LET(
grouped, GROUPBY( Table[Group], Table[Res.], SUM,, 0 ),
filled_res, XLOOKUP( Table[Group], CHOOSECOLS( grouped, 1 ), CHOOSECOLS( grouped, 2) ),
sorted, SORTBY( Table,
filled_res, 1,
SEQUENCE( ROWS( Table ) ), 1
),
IF( ISBLANK( sorted ), "", sorted )
)
Thanks a lot. I’ll check this out and get back to you on how it goes👍🏻