• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find highest and lowest number less than and greater than a value

I'm stumped. I need equations to solve the problem in Rows 9 and 20. The correct answers are in Rows 10 and 21. I prefer a result that does not require an array if possible. The sample excel file is also attached. Thanks for the help.




Active Member
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.
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.

GraH - Guido

Well-Known Member
@pecoflyer , you are spot on and the forum platform allows this.
@Hui , @r1c1 would that not be something to consider? I think knowing the version of excel and the operating system it is on, really helps to offer working solutions considering the OP's context.