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

1. ## 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)

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.

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

Give the attached UserForm approach a try.
torachan.

Title descriptive. Thanks for changing

Hi there,

Let see if I've managed this correctly.

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

7. ## 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.

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