Min of range where other col has a value
 

Hi, I'm trying to pull the min number from a col, where the value in another
col is defined.
ie.
A 5
B 2
A 2
C 7
A 10
B 1
C 5

I need to pull the min for A. I looked up DMIN but the Help doesn't do my
any good. Thought combo of MIN and SUMPRODUCT might work but can't get the
syntax right.

Anyone know how to do this?

Min of range where other col has a value
 

Try this array** formula:

=MIN(IF(A1:A7="A",B1:B7))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Pete Derkowski" wrote in message
...
Hi, I'm trying to pull the min number from a col, where the value in
another col is defined.
ie.
A 5
B 2
A 2
C 7
A 10
B 1
C 5

I need to pull the min for A. I looked up DMIN but the Help doesn't do
my any good. Thought combo of MIN and SUMPRODUCT might work but can't
get the syntax right.

Anyone know how to do this?

Min of range where other col has a value
 

Yep! That did the trick.

Thanks Biff!




"T. Valko" wrote in message
...
Try this array** formula:

=MIN(IF(A1:A7="A",B1:B7))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Pete Derkowski" wrote in message
...
Hi, I'm trying to pull the min number from a col, where the value in
another col is defined.
ie.
A 5
B 2
A 2
C 7
A 10
B 1
C 5

I need to pull the min for A. I looked up DMIN but the Help doesn't do
my any good. Thought combo of MIN and SUMPRODUCT might work but can't
get the syntax right.

Anyone know how to do this?

Min of range where other col has a value
 

You're welcome. Thanks for the feedback!

Biff

"Pete Derkowski" wrote in message
...
Yep! That did the trick.

Thanks Biff!




"T. Valko" wrote in message
...
Try this array** formula:

=MIN(IF(A1:A7="A",B1:B7))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Pete Derkowski" wrote in message
...
Hi, I'm trying to pull the min number from a col, where the value in
another col is defined.
ie.
A 5
B 2
A 2
C 7
A 10
B 1
C 5

I need to pull the min for A. I looked up DMIN but the Help doesn't
do my any good. Thought combo of MIN and SUMPRODUCT might work but
can't get the syntax right.

Anyone know how to do this?