Monday, December 31, 2012

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    Dec 31, 2012
user Ron01 said:(!category-topic/docs/spreadsheets/HMfOCW2JO7M)
How can i find the 2nd largest number in an array?

I know that i can use, lets say:
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?

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.