Excel Magic Trick 914: Top 5, Bottom 5 Excluding Zeros: LARGE, SMALL & AGGREGATE Functions

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT914.xlsx Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to show the top and bottom 5 values excluding zeros using: 1. SMALL Function for bottom 5 with IF Functions to exclude zeroes 2. LARGE Functions for Top 5 with IF Functions to exclude zeroes 3. AGGREGATE Function and array abilities to exclude zeros 4. See IF and IFERROR Functions to hide errors 5. 4 examples of array formulas