Min IF & Max IF

[Varoslaw]

Good day to you all fellow Excel users


I am having some sort of problem with function min if and max if.
My function stands as

=MIN(IF([@[ID]]=[ID];[Administration])).

As you can see in the picture, the formula does work on the Function Window. Giving me a min at the first row of 118.91.
However, when I accept the function, it gives me the same result as in the rest of the rows, 83.14.




I have checked the format of the cells and thats not it and I dont know what else to do.
Can anybody help me ?

 

[AhoyNC]

Not sure if this is the problem, but this is an array formula and needs to be entered with CTRL-SHIFT-ENTER (not just enter).

 

[Varoslaw]

Actually that was the problem and it is now solved! Yay!

Thanks AhoyNC

 

[AhoyNC]

Good an easy fix. Thanks for the feedback and welcome to the forum.