Find the nth position of a number in an array

Excel has a very simple formula which helps you find which number in a given array comes in a given position when the numbers are reviewed from highest to lowest The LARGE formula :


=LARGE(A1:F1,2)


. . . tells us which number in row 1 from columns A to F is the second highest.