Highest Eleven specific values and names returned.

Good afternoon,

How can i make a best XI team from a list of weekly scores in my Fantasy Football league?

Players are as follows:-

One goalkeeper - Top scoring goalkeeper per week
Four defenders - Top four scorers per week
Three midfielders - Top three scorers per week
Three forwards - Top three scorers per week

I need it to find the top scoring players in the above categories and then display them in a specified area.

I also need this to happen for each individual week, NOT cumulative. literally, the highest scoring XI players, as listed above, for the present week.

password for the workbook is - bouvier

any help would be fantastic.

thank you.