Forum Discussion
MIN function exclude "Zero" values - Non Consecutive group of cells
I am struggling with ignore zero values when the group of cells to be tested is not a consecutive range The function "=MIN(D7,M7,V7,AE7,AN7)" works fine but I want to ignore lowest value if AE7 a...
Martin_Angosto,
Thanks for your reply, however, when typing =MIN(CHOISIR({1;2;3;4};AQ6;BN6;CK6;DH6);2) It reverts either 2 or the minimal value among AQ,BN;CK & DH.
Feels like I'm missing something here.
Thanks for your reply, however, when typing =MIN(CHOISIR({1;2;3;4};AQ6;BN6;CK6;DH6);2) It reverts either 2 or the minimal value among AQ,BN;CK & DH.
Feels like I'm missing something here.
Sorry for not translating it before. You shouldn't use MIN but PETITE.VALEUR.
=PETITE.VALEUR(CHOISIR({1;2;3;4};AQ6;BN6;CK6;DH6);2)
