minimum function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 columns of data. In the fifth column I want to find the minimum of
the four data cells in the same row (i.e. A1 thru A4, find min in A5) but I
want to exclude negative, zero, text or blank values. That is, I want the
min of the vales greater than zero but there may also exist blank or text
values in the cells that should not be included.

Thanks in advance!
 
However, A1:A4 is 4 rows of data. Change A1:A4 to A1:D1 if you really
mean 4 columns.

=IF(COUNTIF(A1:A4,">0")=0,"",MIN(IF(ISNUMBER(A1:A4)*(A1:A4>0),A1:A4)))

Entered with Ctrl+Shift+Enter rather than enter since this is an array
formula
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(N(A1:A4)>0,A1:A4))
 
Try the following array formula:


=MIN(IF((IF(ISERROR(A1:A4),"",A1:A4)>0)
*(ISNUMBER(IF(ISERROR(A1:A4),"",A1:A4))>0),
IF(ISERROR(A1:A4),"",A1:A4),""))



--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--
 

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 function but want to exclude zero 2
In part of a col of data, I need the minimum number, but exclude z 10
Conditional Formatting Minimim Value 2
Finding the MIN value, but greater than zero 2
How to find a result in an array in the same row as a minimum resu 3
MAX / MIN function problem 4
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Conditional Formating Absolute Minimums 2

Back
Top