How to return min value, but only values>1 ?

  • Thread starter Thread starter Guest
  • Start date Start date
Eg: If your range of values is A1:A7 then you could type the following
formula into a cell and press CTRL+SHIFT+ENTER to get the correct result.

=MIN(IF(A1:A7>1,A1:A7))
 
=MIN(IF(A1:A10>1,A1:A10))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Average (exclude 1 min & 1 max Value) 2
Min? 3
Min Excluding Value 8
Return cell reference rather than value 4
Complicated vlookup/min-max query...please help 6
Return Min & Cell address 7
Lookup returning #n/a 1
Address function to return values from min row 3

Back
Top