For reference, column H has a formula that calculates an average of all 4 scores.
The classic solution is to use the AVERAGE function with the LARGE function as explained below.
Legacy Excel
InLegacy Excel, the SEQUENCE function does not exist.
The classic solution for creating a numeric array in older versions of Excel is to use theROWandINDIRECTfunctions.
AVERAGE Function
The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers.
SEQUENCE Function
The Excel SEQUENCE function generates a list of sequential numbers in an array.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
