Excel Dashboards: Show top/bottom values
If you have used the MAX and MIN functions in Excel, then you know they return a single value representing the highest and the lowest value in a given range. LARGE and SMALL functions on the other hand allow you to specify whether you want the 2nd, 3rd, 4th, largest/smallest value in the same rang