Use the LARGE function to determine the kth-largest value in a range : WorksheetFunction « Excel « VBA / Excel / Access / Word
- VBA / Excel / Access / Word
- Excel
- WorksheetFunction
Use the LARGE function to determine the kth-largest value in a range
Sub func()
SecondHighest = WorksheetFunction.Large(range("NumberList"), 2)
End Sub
Related examples in the same category