Thread: adding two highest numbers formulae
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default 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.

Reply With QuoteReply With Quote