Min function

  • Thread starter Thread starter oldjay
  • Start date Start date
O

oldjay

I want to find the smallest number in a column that is not
zero or negative
 
=Min(if(and(isnumeric(A1:A500),A1:A500>0),A1:A500)

entered with Ctrl+Shift+Enter

since this is an array formula.
 
oldjay

One way:

=MIN(IF(B2:B100>0,B2:B100))

This is an array formula to be entered with <Shift><Ctrl><Enter>,
also if edited later. If done correctly, Excel will display the formula
in the formula bar enclosed in curly brackets { }. Don't enter these
brackets yourself.
 
You must log in or register to reply here.

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 a minimum 2
Second Smallest Number in a Set 8
Finding Smallest Date in Non Contiguous Range 3
Graphing Negative Time 1
Min Max function 2
How to group 1
Sorting numbers 1
MINIF function 3

Back
Top