How to Get the Smallest Number in Excel

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.

Leave a Reply