1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel AutoMIN

Find the Smallest Number in Excel


Find the Smallest Number in Excel

Find the Smallest Number in Excel

© Ted French

The AutoMIN function is a shortcut to using Excel's MIN function. It provides a quick way to find the smallest number in a list of data in a spreadsheet.

The syntax for AutoMIN is the same as the MIN function.

= MIN ( Number1, Number2, ... Number255 )

Up to 255 numbers can be entered into the function.

Excel's AutoMIN Feature Example

For help with this example, see the image above.

  1. Enter the following data into cells C1 to C6:
    11, 14, 16, 13, 15, 12
  2. Make sure that cell C7 - the location where the results will be displayed is blank.

  3. Drag select cells C1 to C6 in the spreadsheet.

  4. Click on the Home tab.

  5. Click on the down arrow beside the AutoSum button on the ribbon to open the drop down menu.

  6. Click on the word MIN in the menu to enter the MIN function into cell C7.

  7. The answer 11 should appear in cell C7 since it is the smallest number in the list of data.

  8. Click on cell C7 and the complete function = MIN (C1 : C6) appears in the formula bar above the worksheet.

Related Tutorials

©2014 About.com. All rights reserved.