Min If function by Part number
 

Well they would wouldn't they? I am surprised it didn't say you had to
upgrade to 2007 <bg

--
---
HTH

Bob


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



"Aaron" wrote in message
...
I hit the "Send to Microsoft" and it said I have to upgrade to 2003.
Thanks again!

"Bob Phillips" wrote:

This wouldn't crasj Excel in itself, it must be something else.

Lock the range down with $, but not the cell being tested against.

=MIN(IF($A$2:$A$200=A2,$B$2:$B$200))


--
---
HTH

Bob


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



"Aaron" wrote in message
...
WOW. I tried this in and it worked (Thank you) but when I filled down
it
crashed excel.... Can this be put in a Functionm macro?

"Bob Phillips" wrote:

=MIN(IF(A2:A200=A2,B2:B200))

which is an array formula, it should be committed with
Ctrl-Shift-Enter,
not
just Enter.
Excel will automatically enclose the formula in braces (curly
brackets),
do
not try to do this manually.
When editing the formula, it must again be array-entered.

Note that you cannot use a whole column in array formulae (prior to
excel
2007), but must use an explicit range.

--
---
HTH

Bob


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



"Aaron" wrote in message
...
Hello,

I have a worksheet that I need a min if function sort of like the
sum
if
function.
I would like the min of QTY in Column "B" by the parts number I have
in
Column "A".
The parts number could repeat many times in Column A.
The inputs are (Range, Critiera, Min range), so in this example I
would
input (A:A,A2,B:B)


example

PN |QTY| Min
P123 | 4 | 2
P123 | 5 | 2
P123 | 6 | 2
P568 | 8 | 8
P568 | 9 | 8
P238 | 5 | 5
P238 | 6 | 5
P123 | 2 | 2

Is this possible?

Thanks, AJ