Rankings Spreadsheet - 5 highest point events scored in 364 days.

[mrquizworthing]

Hi there,

I have a rankings spreadsheet where I have a list of tournaments with dates and points achieved by each player for the last two years or so.

What I would like Excel to do;
When I input a date in Cell A1, the spreadsheet will calculate the 5 highest tournaments/points scored by each player in the last 52 weeks (364 days) looking at cell A1 and looking back to see the eligible tournaments first and then return the 5 highest points scoring events.

Any advice on how to do this?

I have player names in Column A
I have the tournaments with dates in the columns P to AZ
Columns B to G are the 5 highest scores with the total score next to it.

Thanks

 

[mrquizworthing]

Hi there,

I have a rankings spreadsheet where I have a list of tournaments with dates and points achieved by each player for the last two years or so.

What I would like Excel to do;
When I input a date in Cell A1, the spreadsheet will calculate the 5 highest tournaments/points scored by each player in the last 52 weeks (364 days) looking at cell A1 and looking back to see the eligible tournaments first and then return the 5 highest points scoring events.

Any advice on how to do this?

I have player names in Column A
I have the tournaments with dates in the columns P to AZ
Columns B to G are the 5 highest scores with the total score next to it.

Thanks

I attach a very quick example of what my spreadsheet kinda looks like: https://docs.google.com/spreadsheets/d/1ziK31VjVLZqjjSkGZEekTXfD_CMl-AugiQjH8VXUf5c/pubhtml