| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum function
How to find the minimum value in the range exclude zero. -- cutyfurby ------------------------------------------------------------------------ cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371 View this thread: http://www.excelforum.com/showthread...hreadid=521326 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
minimum function
Hi cutyfurby,
this array formula worked for me to return the minimum of A1:A10... =MINA(IF(A1:A10=0,"",A1:A10)) after typing the formula you must commit it using Ctrl + Shift + Enter Ken Johnson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
minimum function
Hello cutyfurby,
You need an array formula: =MIN(IF(E1:E50,E1:E5)) You will need to press Ctrl+Shift+Enter to confirm the formula not just Enter Judith -- Hope this helps "cutyfurby" wrote: How to find the minimum value in the range exclude zero. -- cutyfurby ------------------------------------------------------------------------ cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371 View this thread: http://www.excelforum.com/showthread...hreadid=521326 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
minimum function
How to find the minimum value in the range exclude zero.
=MIN(IF(A1:A10<0,A1:A10)) Entered as an array using the key combo of CTRL,SHIFT,ENTER. Biff "cutyfurby" wrote in message ... How to find the minimum value in the range exclude zero. -- cutyfurby ------------------------------------------------------------------------ cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371 View this thread: http://www.excelforum.com/showthread...hreadid=521326 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
