A Brief Guide to using the Large Function in Excel. All of this also applies to the Small function.
This video shows how to use the basic features of the function for single numbers from a contiguous array.
Array outputs 1:35 to give outputs to multiple cells or use these arrays for further functions such as sum or average.
Array inputs that are non-contiguous 4:30 (this just requires the right choice of brackets)
Ещё видео!