Leaderboard

**Augusta** · 12-23-2011, 05:40 AM

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

**Richard Buttrey** · 12-23-2011, 06:15 AM

Hi,

Please explain your terminology and which ranges are involved.

What do you mean when you say you want to keep the whole row together? Are you saying that you want to automatically sort the range A6:Z15 by column X?ascending

**Augusta** · 12-23-2011, 07:25 AM

Hi Richard,

Thanks for your reply.

Yes the range of data invloved would be A6:Z15. By keeping the row together I mean all Louis's row (his scores and total) would stay with him. So by sorting column 'X' (lowest score at top), if say Adam gets to 65 making him the new leader all his corresponding scores from each hole would move with him in his row.

The actual leaderboard though is determined only by the total in column 'X'.

Hope this is a bit clearer.
Thanks again

**micope21** · 12-23-2011, 11:19 AM

Try

=RANK(A6,$A$6:$A$15,1) mean Low Score to High Score. Then next column follow =SUMPRODUCT(($Y$6:$Y$15=Y6)*($AD$6:$AD$15>$AD6))). Then column follow number from 10 to 1. Sheet 2 =IFERROR(VLOOKUP($A6,Sheet1!$A$6:$Y$15,C$1,FALSE),"") from Sheet 1. You see C$1 number is put in 2 in c1 follow next column is 3 in D$1 follow next column E$1 so on so on. Make Job easy to copy across.

Here the file enjoy. Merry Xmas

**Richard Buttrey** · 12-23-2011, 11:54 AM

Hi,

One way,

Name the range A6:Z15 'Scores' and run the following macro

Please Login or Register  to view this content.

**Augusta** · 12-28-2011, 10:01 AM

Hi Richard,

Thanks for your help, that's just what I'm after

Leaderboard

LinkBack

Thread Tools

Rate This Thread

Display

Leaderboard

Re: Trying to create a leaderboard

Re: Trying to create a leaderboard

Re: Trying to create a leaderboard

Re: Trying to create a leaderboard

Re: Trying to create a leaderboard

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions