software

I have about 6 columns of data, but only 3 are important in what I'm
trying to find. Here is an example of my spreadsheet:

Score FY Awarded
131 2001 1
145 2001 1
120 2001 0
256 2002 0
344 2002 1
138 2002 1
111 2002 0

Rows 5 through 49 have these data.

etc... up until FY 2006. The data are assorted by FY ascending. 1 in
the Award column means it was awarded, 0 means it wasn't. I want to
find a formula, if possible, that will find the minimum score that was
awarded in each FY. I was able to do it with this:
=DMIN($F$5:$K$49,quot;Scorequot;,F1:K2) where the criteria are quot;=2001quot; or
whichever FY I am interested in and quot;gt;0quot; for the FY column. But, this
is messy because I have to either set up several database headers, or
manually go in and change whichever FY I am searching for. Clearly I
can do this all manually, but I want to find a formula where all I have
to do is change the FY in the formula to get my result. I've also been
trying things like:

=MINA(IF((AND($H$6:$K$49=2001,$K$6:$K$49gt;1)),$F$6: $F$49))Thoughts? Is what I'm trying to do even possible? Or should I just go
in and do it all manually...

Thanks in advance--
Weissme
------------------------------------------------------------------------
Weissme's Profile: www.excelforum.com/member.php...oamp;userid=34044
View this thread: www.excelforum.com/showthread...hreadid=544071=MIN(IF(($H$6:$K$49=2001)*($K$6:$K$49=1),$F$6:$F$4 9))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Weissmequot; gt; wrote in
message ...
gt;
gt; I have about 6 columns of data, but only 3 are important in what I'm
gt; trying to find. Here is an example of my spreadsheet:
gt;
gt; Score FY Awarded
gt; 131 2001 1
gt; 145 2001 1
gt; 120 2001 0
gt; 256 2002 0
gt; 344 2002 1
gt; 138 2002 1
gt; 111 2002 0
gt;
gt; Rows 5 through 49 have these data.
gt;
gt; etc... up until FY 2006. The data are assorted by FY ascending. 1 in
gt; the Award column means it was awarded, 0 means it wasn't. I want to
gt; find a formula, if possible, that will find the minimum score that was
gt; awarded in each FY. I was able to do it with this:
gt; =DMIN($F$5:$K$49,quot;Scorequot;,F1:K2) where the criteria are quot;=2001quot; or
gt; whichever FY I am interested in and quot;gt;0quot; for the FY column. But, this
gt; is messy because I have to either set up several database headers, or
gt; manually go in and change whichever FY I am searching for. Clearly I
gt; can do this all manually, but I want to find a formula where all I have
gt; to do is change the FY in the formula to get my result. I've also been
gt; trying things like:
gt;
gt; =MINA(IF((AND($H$6:$K$49=2001,$K$6:$K$49gt;1)),$F$6: $F$49))
gt;
gt;
gt; Thoughts? Is what I'm trying to do even possible? Or should I just go
gt; in and do it all manually...
gt;
gt; Thanks in advance
gt;
gt;
gt; --
gt; Weissme
gt; ------------------------------------------------------------------------
gt; Weissme's Profile:
www.excelforum.com/member.php...oamp;userid=34044
gt; View this thread: www.excelforum.com/showthread...hreadid=544071
gt;

Hi, Thanks! I will try that, but I also found that this works:

{=MIN(IF($K$6:$K$49=1,IF($H$6:$H$49=O10,$F$6:$F$49 )))}

Most exciting triumph of my day I think.

Thanks again!--
Weissme
------------------------------------------------------------------------
Weissme's Profile: www.excelforum.com/member.php...oamp;userid=34044
View this thread: www.excelforum.com/showthread...hreadid=544071Mine has one les IF lt;vbggt;

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Weissmequot; gt; wrote in
message ...
gt;
gt; Hi, Thanks! I will try that, but I also found that this works:
gt;
gt; {=MIN(IF($K$6:$K$49=1,IF($H$6:$H$49=O10,$F$6:$F$49 )))}
gt;
gt; Most exciting triumph of my day I think.
gt;
gt; Thanks again!
gt;
gt;
gt; --
gt; Weissme
gt; ------------------------------------------------------------------------
gt; Weissme's Profile:
www.excelforum.com/member.php...oamp;userid=34044
gt; View this thread: www.excelforum.com/showthread...hreadid=544071
gt;