When you have a spreadsheet packed with data,finding the number you needcan be tedious.
you could also locate the second smallest, third smallest, or fifth largest.
Use the SMALL Function
The syntax for the function is
where both arguments are required.
You’ll enter the range or array for the
argument.
If you haveduplicate numbersin your data, your result is skewed when finding different positions.
Here’s an example.
The result is 1,800, which is correct.
This is because 1,800 appears twice, making it both the largest and second largest number.
Consider this limitation when searching for various positions in your cell range.
For more, learn how touse INDEX and MATCHto find specific values or how tofind range in Excel.
