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