The real value in LARGE is the ability to request the second largest value with =LARGE(B2:B100,2). In the image below you can see the LARGE and SMALL for a full set of 10 data points.
How to find first 3 values in Excel?
Use the =LARGE(array,k) function to return the largest, second largest, third largest, and kth largest value in a range. To set up the formulas, first create a helper column numbered 1, 2, and 3 as shown in K6:K8 in Figure 3.
How to find the top 5 values in Excel?
Select cell B2, copy and paste the formula =LARGE(A$2:A$16,ROWS(B$2:B2)) into the formula bar, and then press Enter. See screenshot: 2. Select cell B2, drag fill handle to cell B6, then the top five values will be displayed.
How to find the largest number in an array in Excel?
In an empty cell, type “=MAX”. Select the cells from which you want to find the largest number. Close the formula with a closing parenthesis. Press Enter and the largest number in your selection will appear in the cell.