Large Function

W

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
 
B

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)
 
N

Niek Otten

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

Bob Phillips

Doh!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top