Average the Top 5 Values - Two Excel Formula Examples

May 16, 2023

In this video, we look at two Excel formula examples to calculate the average of the top 5 values in a range. We have some students and 8 exam scores. We want to know the average of the top 5 scores for each student. Choose your favourite of the two formula examples and tell me your favourite in the comments below. In the video, we finish with a little bonus. We highlight the value in the list which is the largest average. This is done with another formula in a Conditional Formatting rule. This makes it easy to identify the best student in a list. Here are the video timings. 00:00 - Introduction 00:38 - Array function for average top 5 values 02:55 - AVERAGEIF to average the top 5 values 05:40 - Conditional Formatting to highlight best top 5 average Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses ***

#Business & Industrial
#Reference