Forum Discussion
minimum of every x-th cell
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.
- To add: when i insert the formular the output is #Name
I changed the , to ;
if I would have left the , there would be an error message like "an error in the formular without further explanaitions"
And the ;4 seems to a problem as well. But I'm not really sure about that.Is it possible to attach your sample as Excel file, not as screenshot?
As for the #NAME try to open my file if it gives such error or not. Formulas in it shall be automatically translated into your locale notation.
