Hi,
I need help trying to figure out the best way to achieve what I want.
I have a spreadsheet with two sheets.
The first sheet is a summary page, with names of people and a column that ultimately should TOTAL the person's highest 6 scores inside a 2 year period.
The second sheet is where all the scores are kept.
Each tournament has 3 columns. Place, Name, Score.
I need the forumla in the summary sheet, to identify the name of the competitor, then look into the scores sheet and find and then total the highest 6 scores attributed to that player.
Bookmarks