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 :
. . . tells us which number in row 1 from columns A to F is the second highest.