minimum function

K

Ken Johnson

Hi cutyfurby,
this array formula worked for me to return the minimum of A1:A10...

=MINA(IF(A1:A10=0,"",A1:A10))

after typing the formula you must commit it using Ctrl + Shift + Enter

Ken Johnson
 
J

JudithJubilee

Hello cutyfurby,

You need an array formula:

=MIN(IF(E1:E5>0,E1:E5))

You will need to press Ctrl+Shift+Enter to confirm the formula not just Enter

Judith
 
B

Biff

How to find the minimum value in the range exclude zero.

=MIN(IF(A1:A10<>0,A1:A10))

Entered as an array using the key combo of CTRL,SHIFT,ENTER.

Biff
 

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

Need to get minimum difference 1
Help needed: Minimum value based upon either/or criteria 3
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
How do I find the minimum value in a range while ignoring zeros? 4
Divide by the minimum non-zero number in a range of cells 22
Minimum array formula. 5
Help! Minimum Excluding zeros across multiple sheets 5
Returning a label rather than a number in pivot table field 1

Top