User Defined Function

  • Thread starter Thread starter dovrox
  • Start date Start date
D

dovrox

How would I write a MinIf function that could be used in the spreadshee
in the same way the "CountIf" function is used.

It would be great to be able to min a range, selecting all values abov
zero.

Any thoughts greatly appreciated
 
Try something like:

In B1: =MIN(IF(A1:A100>0,A1:A100))

Array-enter with CTRL+SHIFT+ENTER
(instead of just ENTER)
 
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.
 
Back
Top