The LARGE function in Excel is a statistical function that returns the nth largest value from a range of cells. It is used to find the largest value in a list, or the second largest value, or the third largest value, and so on.
The syntax for the LARGE function is:
- array is the range of cells to be evaluated
- k is the position of the largest value that you want to find, with 1 being the largest value, 2 being the second largest value, and so on.
For example, if you have a range of cells A1:A5 with the values 5, 8, 12, 7, and 3, the formula =LARGE(A1:A5, 2) would return 8, which is the second largest value in the range.