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. I did the same with Maximum which (I don't know why, but doesn't work as well, but sometimes it does): {=MAX(WENN(REST(ZEILE(K8:K390);4);(K8:K390)))} and for min: {=MIN(WENN(REST(ZEILE(K9:K391);4)*0;(K9:K391)))} and it did not want to work the way I want it to :D. I know it has something to do with the "*0" but I don't know how to exclude 0 as a value otherwise. I hope you understand what my problem is. Nevertheless I hope you have a nice day Greets Lisa