Excel: finding 2nd highest value 1

[mickeyg]

In Excel I can use the max function to find the highest value, but how can I find the 2nd highest value in a column?

Thanks in advance,
Mickey

 

[Sypher2]

Try using the Large function. It has this syntax:

=LARGE(array,k)

You would select your column of numbers for "array", then the number of the position for "k". Say you have numbers in cells A1 thru A100 and want to find the second largest:

=LARGE(A1:A100,2)

Hope this helps.

 

[SkipVought]

Hi,
Use this as a spreadsheet function. Ite will return the second highest value:

Function MaxVisible(rng As Range)
    Dim Max, MaxVal
    MaxVal = Application.Max(rng)
    Max = 0
    For Each cell In rng
        With cell
            If .Value < MaxVal Then _
                If .Value > Max Then Max = .Value
        End With
    Next
    MaxVisible = Max
End Function

Skip,
metzgsk@voughtaircraft.com

 

[ETID]

The large function is by far the quickest, easiest way.

 

[mickeyg]

Thanks guys!
I did go with the LARGE function.

Mickey