|
Large Function
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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
=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) "wjohnson" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
Are you sure you need the LARGE() function, not MAX()?
Please state your functional requirements -- Kind regards, Niek Otten "wjohnson" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
Hi!
How about using MAX instead? =MAX(A1,B5,C6) Biff "wjohnson" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
Doh!
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Biff" wrote in message ... Hi! How about using MAX instead? =MAX(A1,B5,C6) Biff "wjohnson" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
Been there, done that!
Biff "Bob Phillips" wrote in message ... Doh! -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Biff" wrote in message ... Hi! How about using MAX instead? =MAX(A1,B5,C6) Biff "wjohnson" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
Forgot all about the MAX Function - It works great, Thanks -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
Large Function
But mine is good if you want the second largest :-(
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "wjohnson" wrote in message ... Forgot all about the MAX Function - It works great, Thanks -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=516016 |
| All times are GMT +1. The time now is 04:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com