| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Help on Large Function | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
