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
You must be logged in to post a comment.