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/

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/

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/