minimum function

W

wiredbliss

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!
 
T

Tom Ogilvy

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
 
F

Frank Kabel

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(N(A1:A4)>0,A1:A4))
 
S

Soo Cheon Jheong

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

How to find a result in an array in the same row as a minimum resu 3
Help needed: Minimum value based upon either/or criteria 3
Conditional Formatting Minimim Value 2
Dynamic pointing to a cell 0
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Finding the MIN value, but greater than zero 2
minimum function but want to exclude zero 2
In part of a col of data, I need the minimum number, but exclude z 10

Top