Home > VBAUsefulCodes
Using the Large function, we can easily find out the nth largest number in a range.
Find nth Largest Number using VBA
Using the Large function, we can easily find out the nth largest number in a range.
Sub func()
SecondHighest = WorksheetFunction.Large(range("NumberList"), 2)
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts