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.