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