Results 1 to 2 of 2

Thread: Running Leaderboard - Help on Ranking Formula

  1. #1

    Running Leaderboard - Help on Ranking Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,

    I'm trying to create a running leader board for a competition we're holding at work.

    On a weekly basis, points will be entered in the yellow cells so competitors can keep track of their progress.

    I've managed to get the "ranking" formulas working (F3-7 and G3-7) however I need the weekly points (yellow cells) to MOVE with the ranking. Is this possible at all? Please see the attached worksheet for what I mean.

    Thanks in advance!

    Debs
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    The only way to do that, I think, would be to duplicate the Week1, Week2, Week3 columns in columns K:M, then insert formula in K3:

    =INDEX(H$3:H$7,MATCH($F3,$B$3:$B$7,0))
    copied across and down.

    You can then differentiate between the 2 sets by saying first set is Input, 2nd set is Aligned Input (or whatever you want to call it to identify it's the properly positioned input values).


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •