MIN, MAX, MODE tec.... from an array???

[Guest]

Hi All
I’ve seen this so many times but none include a function for blank cells?

I’m trying to find the min, max, mode, median etc…. for a list of values
given an IDL (CELL F12) to look up.

The data range is B14 to H1574 and the columns headings are
IDS (B13), Yield (G13), UTS (H13)

What I’m trying to do is find the MIN value for Yield where the look up ID
(IDL)
Equals IDS.
I cam up with the following formula but it returns 0 as there are some rows
with blank cells?

MIN (IF($B$14:$B$1574=F12,G$14:G$1574))

How then do I find the min value omitting the blank ones?

 

[Bob Phillips]

Try this variation

=MIN(IF(($B$14:$B$1574=F12)*(G$14:G$1574<>0),G$14:G$1574))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)