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