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


G

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?
 
Ad

Advertisements

B

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)
 

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

Top