Average top 3 numbers

For an average of top 3 numbers, use the combination of the AVERAGE function and the LARGE function. Follow these steps to do so:

1– Go to F5 cell, type “=AVERAGE”.

2– Type “LARGE” and select the LARGE function by pressing the tab button.

3– Excel will create options against the LARGE function.

4– Select cells B5:E5 against the array argument and {1,2,3} against the k argument.

5– Result.

Copy and paste the formula into other cells.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved