how to excel in line with the terms of reference to the value of a space cell

For example, a value of (12,42,13,15,62,51,15,51) to the 6th position of the numerical reference to the air of a cell, how do I ask?


D1 = LARGE ((12,42,13,15,62,51,15,51), 6)
in descending order for the first 6 A large number of (15)
LARGE (array, k)

Array need to choose a section k maximum value or an array of data.

K for the return value in the array Or in the location of the data range (smallest row).

D2 = index ((12,42,13,15,62,51,15,51), 6)
this Direct extraction for the 6th number (51)

Leave a Reply