Excel Magic Trick 1543: MAXIFS & MINIFS to Lookup Numbers on Either Side of Hurdle

Download Excel Start Files: http://bit.ly/2EfpEfI
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to lookup numbers on either side of a hurdle using MAXIFS and MINIFS Functions which are available in Office 365 or Excel 2019. This trick comes from brianxyz at YouTube!
Original question:
I have 3, 6, 7, 13, 15, 18, 19 in a column and I want the first number greater and less than 11. (I want 7 in a cell and 13 in a different cell).

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.