software

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--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=516016=SUMPRODUCT(LARGE(INDIRECT({quot;A1quot;,quot;B5quot;,quot;C6quot;})),1)

or

=SUMPRODUCT(MAX(INDIRECT({quot;A1quot;,quot;B5quot;,quot;C6quot;})))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;wjohnsonquot; gt; wrote in
message ...
gt;
gt; Can I use the LARGE Function with individual Cells or do they have to be
gt; next to each other, (i.e A1:A6)?
gt; Using the following I would like to have the value of B5 display in
gt; Cell E5 using the LARGE Function.
gt; Cell A1=10
gt; Cell B5=20
gt; Cell C6=15
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile:
www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=516016
gt;
Are you sure you need the LARGE() function, not MAX()?
Please state your functional requirements

--
Kind regards,

Niek Otten

quot;wjohnsonquot; gt; wrote in
message ...
gt;
gt; Can I use the LARGE Function with individual Cells or do they have to be
gt; next to each other, (i.e A1:A6)?
gt; Using the following I would like to have the value of B5 display in
gt; Cell E5 using the LARGE Function.
gt; Cell A1=10
gt; Cell B5=20
gt; Cell C6=15
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=516016
gt;
Hi!

How about using MAX instead?

=MAX(A1,B5,C6)

Biff

quot;wjohnsonquot; gt; wrote in
message ...
gt;
gt; Can I use the LARGE Function with individual Cells or do they have to be
gt; next to each other, (i.e A1:A6)?
gt; Using the following I would like to have the value of B5 display in
gt; Cell E5 using the LARGE Function.
gt; Cell A1=10
gt; Cell B5=20
gt; Cell C6=15
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=516016
gt;
Doh!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; How about using MAX instead?
gt;
gt; =MAX(A1,B5,C6)
gt;
gt; Biff
gt;
gt; quot;wjohnsonquot; gt; wrote
in
gt; message ...
gt; gt;
gt; gt; Can I use the LARGE Function with individual Cells or do they have to be
gt; gt; next to each other, (i.e A1:A6)?
gt; gt; Using the following I would like to have the value of B5 display in
gt; gt; Cell E5 using the LARGE Function.
gt; gt; Cell A1=10
gt; gt; Cell B5=20
gt; gt; Cell C6=15
gt; gt;
gt; gt;
gt; gt; --
gt; gt; wjohnson
gt; gt; ------------------------------------------------------------------------
gt; gt; wjohnson's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=29640
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=516016
gt; gt;
gt;
gt;
Been there, done that!

Biff

quot;Bob Phillipsquot; gt; wrote in message
...
gt; Doh!
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; How about using MAX instead?
gt;gt;
gt;gt; =MAX(A1,B5,C6)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;wjohnsonquot; gt; wrote
gt; in
gt;gt; message ...
gt;gt; gt;
gt;gt; gt; Can I use the LARGE Function with individual Cells or do they have to
gt;gt; gt; be
gt;gt; gt; next to each other, (i.e A1:A6)?
gt;gt; gt; Using the following I would like to have the value of B5 display in
gt;gt; gt; Cell E5 using the LARGE Function.
gt;gt; gt; Cell A1=10
gt;gt; gt; Cell B5=20
gt;gt; gt; Cell C6=15
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; wjohnson
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; wjohnson's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=29640
gt;gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=516016
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;

Forgot all about the MAX Function - It works great, Thanks--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=516016But mine is good if you want the second largest :-(

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;wjohnsonquot; gt; wrote in
message ...
gt;
gt; Forgot all about the MAX Function - It works great, Thanks
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile:
www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=516016
gt;