For example, if you want to find the second largest number in a range of cells in column C the formula would look like:
- =LARGE is the name of the function
- (C5:C305, is the range of cells (data set) of the numbers to be examined
- 2) is the k-th largest number within that data set
The SMALL function works the same way.