Excel's LARGE, SMALL, and RANK functions can be used for ranking numbers in order of relative size. These tutorials includes step by step examples on how to use these functions for ranking numbers in Excel.
Excel 2007 RANK Function
Excel RANK Function
The RANK function is used for ranking a number relative to other numbers in a list a data in Excel 2007.
Excel LARGE Function
Excel LARGE Function
The LARGE function can be used to find data based on relative size - such as the fourth largest number in a given list of data.
Excel SMALL Function
Excel SMALL Function
The SMALL function can be used to find data based on relative size - such as the fifth smallest number in a given list of data.
