View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JV JV is offline
external usenet poster
 
Posts: 1
Default 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.