I want to have a formula that calculates the average of the two highest %back for each athlete using specific races. I have not been able to find a way to select more than 3 races as it will not work. For example: =(SUM(LARGE(J3,L3,P3,1),LARGE(J3,L3,P3,2)))/2 The second set of data points (J3,L3,P3) will not be selected a second time.
Solved by F. F. in 12 mins