yogi_Find 1st 2nd 3rd ... Largest Non-Unique And Unique Numbers In Range A2 to F2

                                          Google Spreadsheet   Post  #948

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 31, 2012
user Ron01 said:(http://productforums.google.com/forum/?zx=7swwh6ge4uwz#!category-topic/docs/spreadsheets/HMfOCW2JO7M)
How can i find the 2nd largest number in an array?
Hi,

I know that i can use, lets say:

=MAX(A2:F2)

to find the the biggest number in the array.

Is there a function, or any other good way to find the 2nd biggest number in that array?

Thanks.

Ron.

---------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem

in addition to a further question by user Ron01 in regard to including corresponding cell references, I have added Sheet2 and Sheet3 wherein the enhanced solution includes cell references as well.