Lowest value in a range

J

James

What formula do i use to find the lowest number in a set of figures, but
ignoring blanks and zero's
 
F

Frank Kabel

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=MIN(IF(A1:A100<>0,A1:A100))
 
A

Aladin Akyurek

=MIN(IF(Range,Range))

which you need to confirm with control+shift+enter instead of just wit
enter.
 

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

Findiing highest and lowest in rows and columns 3
Trying to find additional ranges outside of min, max, and average 2
I need my SMALL formula to ignore zero's 7
Extract the 2 Lowest % 3
Using MIN function 3
Trying to subtract the two lowest values from a row of numbers 4
Subtraction from the lowest number postion wise in Column 3
INDEX MATCH SMALL 13

Top