Forum Discussion
minimum of every x-th cell
Hello everyone, I'm kind of new to working professional with excel. I'm trying to figure out how to do: Searching the Minimum value of line (K8:K320) of every fourth cell, but without the value 0. ...
Hi,
That could be
=AGGREGATE(15,6,1/(MOD(ROW($K$8:$K$390),4)=0)/($K$8:$K$390<>0)*$K$8:$K$390,1)
Please see attached