Excel Forum

Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula

See a great array formula from pgc01 and Aladin at the Mr Excel Message Board that will average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.