Welcome to Excel Avon
How to use LARGE & SMALL formulas in Excel
Summary
In this formula you can learn LARGE formula in Excel, A large function in excel is an inbuilt statistical function that returns the nth position or Kth position from the selected numerical array. If the Kth position is greater or larger than the values, there is an array, or we keep the Kth position as blank then it will return #Num!
Formula
=LARGE (array, k)
Arguments
array – This is the range or array from which you want the function to return the nth largest value.
Kth_position – This is an integer that specifies the position from the value, which is the largest, i.e., the Kth position.
Note:
-
- If array contains no numeric values, LARGE returns a #NUM! error.
- For example, the LARGE Function can be used to find the first, second, or the third-highest scores of a test.
How to use LARGE formula in Excel
So now we will apply the LARGE formula and select the entire range and select the position. Now I will apply for all below cells for to positions number cells. And double click to see the formula. Select the range for locking range and press F4. and Now I will press enter and fill down formula same formula to all below cells.
(according attached below image)
How to use SMALL formula in Excel
The excel small formula is the formula that is responsible for returning the Nth smallest value from the supplied set of value.
formula
= SMALL(array, k)
Arguments
array – This is the range or array from which you want the function to return the nth largest value.
kth_position – This is an integer that specifies the position from the value, which is the largest, i.e., the Kth position.
So now we will apply the small formula and select the entire range and select the position. Now I will apply for all below cells for to positions number cells. And double click to see the formula. Select the range for locking range and press F4. and Now I will press enter and fill down formula same formula to all below cells.
(according attached below image)
So I hope you understand the formula.
You can also see well explained video here
