Hi - Dave here.
Happy Friday!
Last week, I shared a formula to
average the top 3 values in a set of data. The formula uses the LARGE function to retrieve the 3 largest values, which are then fed into the AVERAGE function to get a final result.
This week, I have a more basic example of the LARGE function in action. Here, we use LARGE to get the top 3 scores for each name in the list. Note that the order of the Quiz scores does not matter. The best score will always appear in column I.
[
Read the article and downlaod the workbook]
The main challenge in this example is to create the
mixed references needed to copy the formula across the range I5:K16. This is explained in the article. The worksheet also includes a very simple example without mixed references. Download the workbook to see how it works.
Excel formulas
We maintain more than 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
