Leaderboard

Hi,

I've tried to search on the forums and google, but I'm a bit new to Excel and have a bit of trouble understanding some of the functions. We have a league that runs for ten weeks, each week with some amount of new/different players. We would like to make a leaderboard that automatically takes the new AND existing names and puts into a one sheet leaderboard. The league runs on every Thursday and Friday of the week, we would like to take the best score of either day to count towards the leaderboard. Is this possible and if not, is there a way to set something similar with minimal manual input?

This is an example of some of the data we need used. Two days a week (best result from either day) for ten weeks are used for the final leader board, with the last two weeks being dropped. We've used the following point system to determine ranking:

WEEKLY LEADERBOARD POINTS
12 points = 6 points
10 points = 5 points
9 points = 4 points
7 points = 3 points
6 points = 2 points
all else = 1 point

Hope that makes sense and thanks for the help!