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