On 4 Nov, 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.


Try:

=INDEX($A$2:$A$5,MATCH(MIN(IF(($B$2:$B$5)="J",($C$ 2:$C$5))),($C$2:$C$5)
*(($B$2:$B$5)="J"),0))

N.B.: Matrix formula (confirm with CTRL+SHIFT+ENTER)

Bye!
Scossa