ExcelBanter - IF COUNT

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF COUNT (https://www.excelbanter.com/excel-worksheet-functions/147161-if-count.html)

sporting8

IF COUNT

If I have values in A1:A3, how do make a formula that will take the highest
two numbers of the 3 values?

Teethless mama

IF COUNT

=LARGE(A1:A3,1)&", "&LARGE(A1:A3,2)

"sporting8" wrote:

If I have values in A1:A3, how do make a formula that will take the highest
two numbers of the 3 values?

Rick Rothstein \(MVP - VB\)

IF COUNT

If I have values in A1:A3, how do make a formula that will take
the highest two numbers of the 3 values?

Take them where? You need to provide more information about what comes next.

Rick

Bob Phillips

IF COUNT

=SUM(LARGE(C1:C3,{1,2}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rick Rothstein (MVP - VB)" wrote in
message ...
If I have values in A1:A3, how do make a formula that will take
the highest two numbers of the 3 values?

Take them where? You need to provide more information about what comes
next.

Rick

All times are GMT +1. The time now is 01:03 PM.