• 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

    Hui...

  • 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.

74886
 

Attachments

  • Sample-worksheet.xlsx
    8.6 KB · Views: 14
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.
 
@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.
 
Please try other approaches

=LARGE(A1:A7,COUNTIF(A1:A7,">5")+1)

=SMALL(A12:A18,COUNTIF(A12:A18,"<5")+1)
 

Attachments

  • Sample-worksheet.xlsx
    9.1 KB · Views: 4
Back
Top