You can implement an Excel statistical function while using a dataset. At times, you need to know the largest value in multiple ranges. Then, we need the LARGE function. In this article, you will learn how to use the Excel LARGE function in multiple ranges.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Introduction to LARGE Function
Objective
The objective of the LARGE function is to return the Kth value in a data set.
Syntax
=LARGE(array,k)
Arguments Explanation
ARGUMENT  REQUIREMENT/OPTIONAL  DESCRIPTION 

array  Required  The array from which we need to find the Kth largest value 
k  Required  An integer that indicates the position from the largest value, as the Nth position

Version
 The LARGE function is available from Microsoft Excel 2007.
 Â Here, we will use Microsoft Excel 365.
2 Suitable Ways of LARGE Function for Multiple Ranges in Excel
We have shown 2 examples where we used ExcelÂ LARGE function in multiple ranges. Like, in the first example, we will use the LARGE function to get the highest value for section A. Then, for the second example, we will combine the LARGE function with other functions such as the INDEX and MATCH functions. By merging other functions with the LARGE function, we can solve different types of problems more efficiently.
Method 1: Using LARGE Function to Find the Highest Value from Multiple Ranges
Here we have a dataset that represents the marks of two sections (Section A and Section B) of class 6. If we want to find the highest marks in section A, we have to apply the formula for multiple ranges.
Steps:
 Firstly, write down the formula in cell D5. You must select the ranges among which you want the largest marks. In this case, we have selected the ranges of section A only.
=LARGE((C5:C6,C10,C13:C14),1)
 Press ENTER to see the result.
 Therefore, you will get the highest mark in section A, which is 88.
Formula Breakdown
 LARGE((C5:C6,C10,C12:C13),1), here, among (array =C5:C6,C10,C12:C13) the LARGE function finds the highest value (K=1).
Read More: How to Use LARGE and SMALL Function in Excel
Method 2: Merging INDEX, MATCH, and LARGE Functions to Get the Nth Largest Values
If we want to know the top 3 scores with the studentâ€™s name, we can merge the INDEX, MATCH, and LARGE functions.
Steps:
 Write the formula in cell F17.
=INDEX($F$5:$F$14,MATCH(LARGE($F$5:$F$14,$E17),$F$5:$F$14,0))
 Now, hit the ENTER key.
 So, here we have the highest mark 96 as a result.
 Lastly, copy it down to cell F19.
 Thus, we have determined the top three marks.
Formula Breakdown
 LARGE($F$5:$F$14,$E17), firstly, this portion finds the highest marks (E17= 1) in the range F5:F14.
 MATCH(LARGE($F$5:$F$14,$E17),$F$5:$F$14,0), afterward, this portion provides the row number of the top scorer in the range F5:F14.
 INDEX($F$5:$F$14,MATCH(LARGE($F$5:$F$14,$E17),$F$5:$F$14,0)), lastly, the INDEX function will return the marks from range F5:F14.
Â
 To get the studentâ€™s name, enter the formula in cell G17.
=INDEX($E$5:$E$14,MATCH(LARGE($F$5:$F$14,$E17),$F$5:$F$14,0))
 After that, click ENTER.
 Therefore, we will get the name of the top scorer.
 Finally, copy the formula down to cell G19.
 Consequently, we will find the names of the top three scorers.
Â Formula Breakdown
 LARGE($F$5:$F$14,$E17), firstly, this portion finds the highest marks (E17= 1) in the range F5:F14.
 MATCH(LARGE($F$5:$F$14,$E17),$F$5:$F$14,0), then, this portion provides the row number of the top scorer in the range F5:F14.
 INDEX($E$5:$E$14,MATCH(LARGE($F$5:$F$14,$E17),$F$5:$F$14,0)), lastly, the INDEX function will return the associated data with the highest value from the range F5:F14.
Read More: How to Use Excel LARGE Function with Criteria( 4 Suitable Ways)
Conclusion
In these two examples, I have shown multiple criteria for using the Excel LARGE function in multiple ranges. There may be some different situations where the formula needs to be modified. If you have any questions regarding this topic, please comment so that we can help.
Related Articles
 How to Find Largest Number in Excel (4 Quick Ways)
 Use Excel Large Function with Text (3 Easy Ways)
 Lookup Next Largest Value in Excel (4 Easy Ways)
 How to Find Largest Lookup Value in Excel (3 Easy Ways)
 [Fixed!] Sort Largest to Smallest Not Working in Excel
 Use VBA Large Function in Excel (4 Suitable Examples)
 How to Find Second Largest Value with Criteria In Excel