Forum Discussion
minimum of every x-th cell
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
thanks for your fast reply.
Sadly it doesn't work.
And I don't quiet get the part with the 15,6,1?
may you help me again :)?
The error message say there's a mistake in the formular.
Did you check the file attached to my previous post? Within it formula works, no errors.
If it is an error in your case please give more detail which one, or even better attach small sample file.
Parameters for AGGREGATE are described here https://support.office.com/en-us/article/aggregate-function-43b9278e-6aa7-4f17-92b6-e19993fa26df. We find first (very last 1) small (15) value ignoring all errors in calculation (6), filtering our range with 1/(..) works as a filter returning errors for the cells which are not met condition.
I've add an attachment with my problem.
I don't know maybe its because I have really small numbers?
The ones I marked are the ones I want to determine the minimum values of.
I don't really know what this formular does, even after reading the blog about it.
I'm sorry I'm really new to the topics.
