Leaderboard

[Augusta]

Hi,

I have a document that will need updating regularly with scores. I'm trying to create a leaderboard that will use the score in column x, and keep the whole row together that corresponds to that child.

Is it possible to input those scores, after competitions and excel will automatically re-order the whole row?

I already have a simple formula in column x which I still need to incorporate.

I have attached the file for your perusal.
Many thanks for your help