Finding the second largest number in an array
Posted on 2014-07-24
Here is a quick question in excel.
We have a numerical array in A1:A100 and want to find out the second largest number. Is there a simple formula to do that?
Assume that we have found out the largest number and put it in B1 = Max(a1:a100), what can we do to use B1 too?