adding two highest numbers formulae
I need to know what is the formulae of adding the two highest/max numbers
within the cells selected. |
adding two highest numbers formulae
Hi Camma,
Try this one : Sub MAX2() MsgBox "First Max: " & Application.Max(Selection) _ & vbCr & "Second Max: " & Application.Max(Selection) - 1 End Sub Rgds, Halim camma menuliskan: I need to know what is the formulae of adding the two highest/max numbers within the cells selected. |
adding two highest numbers formulae
Var1 = WorksheetFunction.Large(Range("A1:A5"),1) + _
Worksheetfunction.Large(Range("A1:A5"),2) Charles Chickering camma wrote: I need to know what is the formulae of adding the two highest/max numbers within the cells selected. |
All times are GMT +1. The time now is 09:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com