This article describes the formula syntax and usage of the LARGE function in Microsoft Excel. Returns the k-th largest value in a data set. You can use this function to select a value based …

Oct 13, 2021 · The Excel LARGE function returns a numeric value based on its position in a list when sorted by value in descending order. In other words, LARGE can retrieve the "nth …

Guide to LARGE Excel Function. Here we explain how to use Large Formula along with step by step examples & a downloadable excel template.

What is the Excel LARGE Function? The Excel LARGE Function [1] is categorized under Excel Statistical functions. The function will return the k largest value, sorted by value in descending …

Nov 9, 2023 · Learn how to use Excel's LARGE function for both Mac and PC. Includes numerous formula examples in Excel and VBA (WITH PICTURES).

This Excel tutorial explains how to use the Excel LARGE function with syntax and examples. The Microsoft Excel LARGE function returns the nth largest value from a set of values.

Jun 8, 2025 · Whether you’re analyzing sales figures, test scores, or any numerical data, the LARGE function helps you quickly identify the highest values without manually sorting your …

In cell B5, when k is set to 5 (the number of values in the supplied array), the Large function performs the same action as the Excel Min function. Further details and examples of the Excel …

To return the nth largest value from an entire column, we can use the LARGE function, and use the whole column as our array. By referencing the entire column, or C:C in this example, the …

Sep 15, 2025 · Use this guide to learn how to use the Excel LARGE function.