+ Reply to Thread
Results 1 to 7 of 7

Help needed creating a ranked leaderboard based on values of tasks completed

  1. #1
    Registered User
    Join Date
    02-08-2021
    Location
    Kent, England
    MS-Off Ver
    Excel for Mac
    Posts
    3

    Help needed creating a ranked leaderboard based on values of tasks completed

    Hi there,

    This is my first post which comes after an entire morning's worth of searching and I have yet to find the answer.

    I am trying to create an employee leaderboard. The idea being employees get a certain number of points based on the task they have completed and these points are totalled, giving the employee a place on the leaderboard. eg. the most points puts them at the top.

    I want to be able to select the task from a dropdown and this automatically applies the assigned points to that employee's total.

    For example:

    We have John, Julie and Jack as my employees (I've made these up by the way, it is for example purposes only)

    I have three tasks:

    washing car = 3 points
    hoovering = 5 points
    washing up =10 points


    Jack has done the washing up, so I want to select "washing up" from a drop down that sits next to his name and that adds 10 points to his monthly total. This means he as over taken Julie who was previously on top of the leaderboard. This automatically moves the names and their points around.

    Does this make sense?

    I am sure there is a way of doing this and I'm also sure it will probably involve multiple sheets and formulas, but I REALLY want to try and get my head around it.

    Thanks very much in advance.
    Last edited by Al1Reid; 02-08-2021 at 10:27 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,907

    Re: Leaderboard

    Welcome to the forum.

    It would help if you attached a sample Excel workbook, as we can't see what you are trying to describe. To do this, follow the instructions in the yellow banner at the top of the screen.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,224

    Re: Leaderboard

    Give the attached UserForm approach a try.
    torachan.
    Attached Files Attached Files

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,896

    Re: Leaderboard

    Title descriptive. Thanks for changing
    Last edited by Pepe Le Mokko; 02-08-2021 at 10:32 AM.

  5. #5
    Registered User
    Join Date
    02-08-2021
    Location
    Kent, England
    MS-Off Ver
    Excel for Mac
    Posts
    3

    Re: Leaderboard

    Hi there,

    Let see if I've managed this correctly.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-08-2021
    Location
    Kent, England
    MS-Off Ver
    Excel for Mac
    Posts
    3

    Re: Leaderboard

    Here we are. Thanks in advance. Appreciate the help.
    Attached Files Attached Files

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,830

    Re: Help needed creating a ranked leaderboard based on values of tasks completed

    This proposal employs a column (J) which may be moved and/or hidden for aesthetic purposes.
    The helper column is populated using: =SUMPRODUCT((E2:I2=A$2:A$5)*(B$2:B$5))
    The Name column is populated using: =INDEX(D$2:D$5,AGGREGATE(15,6,(ROW(D$2:D$5)-ROW(D$1))/(J$2:J$5=Q3),COUNTIFS(Q$3:Q3,Q3)))
    The Points column is populated using: =LARGE(J$2:J$5,O3)
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Help with a Racing Leaderboard
    By freddiehick in forum Excel General
    Replies: 8
    Last Post: 12-12-2020, 04:15 PM
  2. Leaderboard
    By kirbster123 in forum Excel General
    Replies: 2
    Last Post: 12-12-2018, 02:37 AM
  3. [SOLVED] Basic leaderboard
    By barber87 in forum Excel General
    Replies: 6
    Last Post: 05-19-2017, 11:25 AM
  4. Golf Leaderboard
    By plus4 in forum Excel General
    Replies: 4
    Last Post: 08-06-2014, 07:17 AM
  5. Making a leaderboard in excel
    By mmaher5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 03:17 PM
  6. Top 10 leaderboard
    By jlevs95 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2012, 03:05 PM
  7. 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