Looking for a conditional minimum value

[JV]

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.

 

[macropod]

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]


| 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.
|

 

[macropod]

PS: change the cell addresses to suit your needs.

--
macropod
[MVP - Microsoft Word]


| 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]
|
|
| | | 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.
| |
|
|