finding a value with parameters
Uzytkownik "Jarek Kujawa" napisal w wiadomosci
...
=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
thank you, but this is the first part. In final answer should be a value
from col A as the same row of found number in C.
It doesn't work with my example.
Col A have values A1, A2, A3, A4. The answer should be "A3".
|