i-nth logo
Average top 3 scores
6 May 2019

This short article shows you how to average the top n values in a set of data.

The technique uses the LARGE function to select the required values, which are then evaluated by the AVERAGE function.

Full article: Average top 3 scores

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us