What does the LARGE function do and how does it differ from MAX?

Question

Microsoft Excel — Medium

What does the LARGE function do and how does it differ from MAX?

Accepted Answer

The LARGE function returns a specific value based on its position in a dataset. It differs from MAX as it can return the Nth largest value. MAX, on the other hand, only returns the largest value. This distinction makes LARGE more versatile for ranking purposes.