G Guest Jun 20, 2007 #1 If I have values in A1:A3, how do make a formula that will take the highest two numbers of the 3 values?
If I have values in A1:A3, how do make a formula that will take the highest two numbers of the 3 values?
R Rick Rothstein \(MVP - VB\) Jun 20, 2007 #3 If I have values in A1:A3, how do make a formula that will take the highest two numbers of the 3 values? Click to expand... Take them where? You need to provide more information about what comes next. Rick
If I have values in A1:A3, how do make a formula that will take the highest two numbers of the 3 values? Click to expand... Take them where? You need to provide more information about what comes next. Rick
B Bob Phillips Jun 20, 2007 #4 =SUM(LARGE(C1:C3,{1,2})) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=SUM(LARGE(C1:C3,{1,2})) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
