Download Excel Start Files: https://excelisfun.net/files/EMT1543.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/files/

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