MIN ingnoring zero sum in an range of cells

  • Thread starter Thread starter Gulicio
  • Start date Start date
G

Gulicio

I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance
 
I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance
Click to expand...


Finally found answer that worked for thoose still looking here it is:

try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:Z1>0,A1:Z1))
 
Based on your original example with multiple ranges:
=min(a1:a10,b1:b10)
Click to expand...

=SMALL(A1:B10,COUNTIF(A1:B10,0)+1)

--
Biff
Microsoft Excel MVP


I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance
Click to expand...


Finally found answer that worked for thoose still looking here it is:

try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:Z1>0,A1:Z1))
 
Back
Top