Large Function

[wjohnson]

Can I use the LARGE Function with individual Cells or do they have to be
next to each other, (i.e A1:A6)?
Using the following I would like to have the value of B5 display in
Cell E5 using the LARGE Function.
Cell A1=10
Cell B5=20
Cell C6=15

 

[Bob Phillips]

=SUMPRODUCT(LARGE(INDIRECT({"A1","B5","C6"})),1)

or

=SUMPRODUCT(MAX(INDIRECT({"A1","B5","C6"})))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Niek Otten]

Are you sure you need the LARGE() function, not MAX()?
Please state your functional requirements

 

[Biff]

Hi!

How about using MAX instead?

=MAX(A1,B5,C6)

Biff

 

[Bob Phillips]

Doh!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Biff]

Been there, done that!

Biff

Doh!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[wjohnson]

Forgot all about the MAX Function - It works great, Thanks

 

[Bob Phillips]

But mine is good if you want the second largest :-(

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)