If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
User Defined Function
How would I write a MinIf function that could be used in the spreadsheet
in the same way the "CountIf" function is used. It would be great to be able to min a range, selecting all values above zero. Any thoughts greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
User Defined Function
Try something like:
In B1: =MIN(IF(A1:A1000,A1:A100)) Array-enter with CTRL+SHIFT+ENTER (instead of just ENTER) -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- "dovrox " wrote in message ... How would I write a MinIf function that could be used in the spreadsheet in the same way the "CountIf" function is used. It would be great to be able to min a range, selecting all values above zero. Any thoughts greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
User Defined Function
Hi
You can use standard excel functions for it With your data p.e. in range A1:A100 =MIN(IF(A1:A100=0,MAX(A1:A100),A1:A100)) entered as array function (Ctrl+Alt+Enter) will do. -- Arvi Laanemets (When sending e-mail, use address arvilAttarkon.ee) "dovrox " wrote in message ... How would I write a MinIf function that could be used in the spreadsheet in the same way the "CountIf" function is used. It would be great to be able to min a range, selecting all values above zero. Any thoughts greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|