Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/SORTBY-Custom-List.xlsx

In this Microsoft Excel video tutorial I demonstrate how to sort by a dynamic custom sort order (one that will update as new data is added) using a single cell spilled array formula.

In my scenario I want to sort a list of players by their average score. The player's scores with the highest average score need to at the top of the list.

00:00 Introduction
01:03 Put your data in a table
01:31 Use UNIQUE to return the player names
02:02 Use AVERAGEIF to calculate the average score for each player
02:47 Use HSTACK to combine the two columns
03:49 Use LET to avoid the circular reference
05:24 Use SORT to sort by average score
05:58 Use XMATCH to calculate each record's sort order
06:54 Use SORTBY to sort records based on the XMATCH results
07:33 Use VSTACK to return the column headings
08:08 Create a single cell formula solution - (using CHOOSECOLS)



#exceltutorial #exceltips #excel365