SMALL and LARGE Excel Functions We all know about MAX and MIN functions. They give you the maximum and minimum values of the selected data respectively.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.