Learn How to Find the Lowest n Values in Microsoft Excel
The main purpose of this formula is to find the n lowest values in a set of data. Here we will learn how to find the lowest n values in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the INDEX, and SMALL functions, you can able to find the n lowest values in a set of data.
So, with the help of this formula, you can able to find the lowest n values in the given data range in the workbook in Microsoft Excel.
General Formula to Find Lowest n Values
=INDEX(rng1,MATCH(MAX(LEN(rng1)*(rng2=criteria)),LEN(rng1)*(rng2=criteria),0))
The Explanation to Find Lowest n Values
So we know that with the help of the given formula above you can able to find the n lowest values in a set of data. Here we will learn how to find the lowest n values in the given data range in the workbook in Microsoft Excel.
As we know that the small function is used to retrieve the smallest values from data based on rank. Next, the MATCH function returns the location of the value to INDEX as a row number.
INDEX function then retrieves the corresponding value from the named range company So now you have learned how to find the lowest n values in the given data range in the workbook in Microsoft Excel.