I don't believe I have MAXIF and MINIF functions in my version of excel. They did not pop up as a selection when typing in the formula bar.MAXIF and MINIF functions?
Yes, this is one of the points that could be improved on the forum, namely showing the XL version in the profile attached to each post.I don't believe I have MAXIF and MINIF functions in my version of excel. They did not pop up as a selection when typing in the formula bar.
Thank you. This works perfectly.Try,
[C3] : =AGGREGATE(14,6,A1:A7/(A1:A7<=5),1)
[C14] : =AGGREGATE(15,6,A12:A18/(A12:A18>=5),1)
View attachment 74890
And have you understood how it works? AGGREGATE is tricky to use, but very usefulThank you. This works perfectly.