minimum value of a range with an "if" condition

C

Carmen

I have a row of numbers that range from 0 to 100. I want to find the minimum number that is also greater than 10, sort of like

=min(A1:A50,">10") which I know will not work. Any help? Thanks in advance.
 
J

JE McGimpsey

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MIN(IF(A1:A50<=10,"",A1:A50))
 

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

minimum value excluding zero 1
Min function with a variable range 2
Conditional format for Highlight first Minimum Value greater than zero 3
MACRO RUN random percentage and copy of column values 1
Calculating the minimum value from a range of times 3
Multiple condition message box 1
How do I use "column" function to get the column number of the firstcell matching criteria? 1
2nd condition in a conditional formatting not working 9

Top