View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default finding a value with parameters

=MIN(IF($A$2:$A$5="j",$B$2:$B$5))

array-enter this formula i.e. with CTRL+SHIFT+ENTER instead of using
ENTER only


On 4 Lis, 11:18, "soonic" wrote:
Hi

Is it possible to make it work in excel in this situation:

I've got 3 columns: A,B,C. I want to find the smallest number in col C, but
including rows with the same value in col B. The answer would be from col A
with the same row as found value in C.

Example:
A * *B * *C
A1 *J * * 8
A2 *K * *4
A3 *J * * 6
A4 *P * * 1

I'm looking for lowest number in col C but including only rows w "J" in col
B. So, the answer should be "A3" in col A.

Any ideas how to make it work?