Find Largest or Smallest Value based on Criteria

If you wanted to find out the biggest or smallest values in a table there’s a couple ways that can be done. Also if you wanted to find the next largest or smallest value, there’ also a function for that. AND...if you had multiple criteria to find big or small values there's recently added functions (Excel 2019 or Office 365) that let you do that. See how all this can be done in the video and there's also a bonus tip on how to create dropdown list.