Calculating the smallest number, similar to counting the average, the sum or the maximum value, is the very basic calculation in Excel. You can get the smallest number with a formula, or you can count the smallest number with the command below:
Step 1: Select the data range;
Step 2: Click the "Home" tab from the ribbon;
Step 3: In the Editing section, click the triangle after the "AutoSum";
Step 4: Select "Min" from the drop-down list;
Step 5: The smallest number will appear at the bottom of the column. In this example, 2 is the smallest number for 2,3,4,5,6.