Looking for a conditional minimum value
 

Would anyone be able to assist me in developing a formula where I am
basically trying to look for a minimum numeric value in a column if the
value in a corresponding column of the same row meets a certain
criterion?

Example: I have two columns. Column A includes alpha values "A", "B",
or "C" (one value per cell in the column). Right next door in Column B
are numeric values. I want to find the minimum value of the values in
Column B adjacent to the value "A" in Column A.

I hope this makes sense!

Thanks.

Looking for a conditional minimum value
 

You must use Array functions for that:
1- in one cell write :
=MIN(IF($A$1:$A$100="A",$B$1:$B$100))
2- press enter
3- press : F2
4- Press : ctrl + shift + Enter
5- Formula Changed to:
{=MIN(IF($A$1:$A$100="A",$B$1:$B$100))} and it work.

"JV" wrote:

Would anyone be able to assist me in developing a formula where I am
basically trying to look for a minimum numeric value in a column if the
value in a corresponding column of the same row meets a certain
criterion?

Example: I have two columns. Column A includes alpha values "A", "B",
or "C" (one value per cell in the column). Right next door in Column B
are numeric values. I want to find the minimum value of the values in
Column B adjacent to the value "A" in Column A.

I hope this makes sense!

Thanks.

Looking for a conditional minimum value
 

Hi JV,

Try the following array formula:
=MIN(IF(A1:A35="A",B1:B35))
To make the formula an array formula, press <Ctrl-<Shift-<Enter instead of
just <Enter after inputting the code.

Cheers

--
macropod
[MVP - Microsoft Word]


"JV" wrote in message
ups.com...
| Would anyone be able to assist me in developing a formula where I am
| basically trying to look for a minimum numeric value in a column if the
| value in a corresponding column of the same row meets a certain
| criterion?
|
| Example: I have two columns. Column A includes alpha values "A", "B",
| or "C" (one value per cell in the column). Right next door in Column B
| are numeric values. I want to find the minimum value of the values in
| Column B adjacent to the value "A" in Column A.
|
| I hope this makes sense!
|
| Thanks.
|

Looking for a conditional minimum value
 

PS: change the cell addresses to suit your needs.

--
macropod
[MVP - Microsoft Word]


"macropod" wrote in message
...
| Hi JV,
|
| Try the following array formula:
| =MIN(IF(A1:A35="A",B1:B35))
| To make the formula an array formula, press <Ctrl-<Shift-<Enter instead
of
| just <Enter after inputting the code.
|
| Cheers
|
| --
| macropod
| [MVP - Microsoft Word]
|
|
| "JV" wrote in message
| ups.com...
| | Would anyone be able to assist me in developing a formula where I am
| | basically trying to look for a minimum numeric value in a column if the
| | value in a corresponding column of the same row meets a certain
| | criterion?
| |
| | Example: I have two columns. Column A includes alpha values "A", "B",
| | or "C" (one value per cell in the column). Right next door in Column B
| | are numeric values. I want to find the minimum value of the values in
| | Column B adjacent to the value "A" in Column A.
| |
| | I hope this makes sense!
| |
| | Thanks.
| |
|
|