Wednesday, 23 April 2014

How to find Average of Large Three Numbers in a Data in Excel

Excel Function to find Average of Large N Numbers in a Data
We can find the Average of Large 'N' numbers from a data as explained below :
Example :
Suppose we have the data at the range C2:C9 , We can find the Average of Large 3 (or 'n') by using the following formulas :

 =AVERAGE(LARGE($C$2:$C$9,{1,2,3}))

or


 {=AVERAGE(LARGE($C$2:$C$9,ROW(1:3)))}


or


 {=AVERAGE(LARGE($C$2:$C$9,ROW(INDIRECT("1:3"))))}




Note :
By using the above method we can find the Average of N Small numbers also.



Thanks.,
TAMATAM

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts