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.






Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com