+ Reply to Thread
Results 1 to 5 of 5

Running Leaderboard - Help on Ranking Formula

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Sydney, Australia
    MS-Off Ver
    2010
    Posts
    2

    Running Leaderboard - Help on Ranking Formula

    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
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

    Re: Running Leaderboard - Help on Ranking Formula

    Hi there... and welcome to the Excel Forum.

    here's one way.
    Attached Files Attached Files
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

    Re: Running Leaderboard - Help on Ranking Formula

    Slightly neater version - removing the unnecessay helper column.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-22-2014
    Location
    Sydney, Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Running Leaderboard - Help on Ranking Formula

    OMG, Glenn, you're AMAZING!! thank you SO MUCH! honestly - you're the best. i appreciate your help SO much

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

    Re: Running Leaderboard - Help on Ranking Formula

    You're welcome!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. problem with a sumproduct formula for a leaderboard sheet
    By indiana115 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2013, 10:44 AM
  2. Ranking a leaderboard with ties without missing numbers
    By rosters in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2012, 09:10 PM
  3. Making a leaderboard in excel
    By mmaher5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 03:17 PM
  4. Top 10 leaderboard
    By jlevs95 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2012, 03:05 PM
  5. Leaderboard
    By Augusta in forum Excel General
    Replies: 5
    Last Post: 12-28-2011, 10:01 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1