Скачать или смотреть How To Find (Calculate) The Smallest Or 3 Smallest Values In A Data Set In Excel Explained

In this video we discuss how to find or calculate the smallest or 3 smallest values in a data set in excel using the SMALL function. We go through a detailed example step by step

Transcript/notes
Let’s say that you want to find the bottom 3, or 3 smallest values in a data set, such as in this example of employees sales numbers.

To do this, we are going to use the small function.

Start by left clicking on the answer cell, here, cell D2, so it is highlighted and then type in an equals sign. From here we type in sma and a pop up box will appear, in the box, we want to left double click on small. Next we need to tell excel the range of cells we want to find the smallest value of, which are the values in column B. So, left click and hold on cell B2, and drag down over the last value, cell B18, and then release the click and hold.

Next we type in a comma, and then we need to enter the number of the smallest place or rank we want to know, which is 1, for 1st smallest value. Now, we type in a closed parenthesis to close off the function and then hit the enter key, and we have our answer 10.

To make it easier to fill in for 2nd smallest and 3rd smallest we are going to modify the formula we entered into cell D2. To do this, left double click on D2, and then we go into the formula and type in a dollar sign in front of both B’s, the 2, and 18, as you see here. This creates an absolute reference to the range of cells, B2 through B18. And then we hit enter.

Next, we again left click on cell D2, and go to the bottom right corner of the cell and the cursor will turn black. From here we drag down to the answer for 3rd smallest, cell D4, and then release the click and hold.

Now we need to adjust the formulas in D3, and D4. So, left double click on D3, and at the end of the formula, change the 1 to a 2, then hit enter and we have 13 as our answer. I am going to do the same in cell D4, change the 1 to a 3, hit enter and we have 20 as the answer.

Chapters/Timestamps
0:00 Intro
0:10 How to find the smallest value in a data set
0:58 Modify formula for 2nd and 3rd smallest values in a data set
1:38 How to find 2nd smallest value in a data set
1:55 How to find 3rd smallest value in a data set