Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions
 

LARGE(array, Position_from_the_largest) returns the k-th largest value in a data set

Input the formula: =LARGE(B2:C6,3). Press Enter to get the result.