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.

Title descriptive. Thanks for changing

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.