Help! Minimum Excluding zeros across multiple sheets
"Peo Sjoblom" wrote...
Try this
=SMALL('1:14'!L35,1+SUMPRODUCT(COUNTIF(INDIRECT(" '"&{1;2;3;4;5;6;7;8;9;10;11;12;13;14}&"'!L35"),0)) )
....
Volatile functions unnecessary for literal 3D references. This could
be done with
=SMALL('1:14'!L35,INDEX(FREQUENCY('1:14'!L35,0),1) +1)
Actually, this could be done just using
=SMALL('1:14'!L35,FREQUENCY('1:14'!L35,0)+1)
but the formula returns an array, so not as useful if the SMALL call
were instead part of a bigger formula.
|