User Defined Function

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
 
M

Max

Try something like:

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

Array-enter with CTRL+SHIFT+ENTER
(instead of just ENTER)
 
A

Arvi Laanemets

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Minimum but if same number repeats in the range, then find 1
can't use function 'countif' in named range 8
Set non-continuous PrintArea via Function / Name 0
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Is there a function to perform this operation? 2
User defined function 5
User Defined Function 5
Finding lowest count in any column 12

Top