In our latest trans-Atlantic Excel tip, David Ringstrom shows how the LARGE and SMALL functions can take some of the drudgery out of finding high/low values in your data.
Ranking the value or performance within an Excel list is a common task. Many people choose to sort data in ascending or descending order, but this tutorial demonstrates how the LARGE and SMALL functions to create an ordered list of the items you want to rank.
Most accountants should be familiar with the MIN and MAX functions in Excel, which return the smallest or largest value within a list.
As we can see here, MIN returns the the smallest value in the list (191) and MAX the largest (958):