Using Excel’s MIN Function

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a range of cells that you specify.

So let’s assume that your list of numbers are in cells A1 to cells A200. Using Excel’s MIN Function will allow us to quickly find the lowest number from this range. Simply write your MIN function in another cell, B1 for example, and then hit enter.

For this example your MIN Function formula would be written like so:

=MIN(A1:A200)

You now have your minimum number for that range!

But… there is one problem with routinely using the MIN Function. The MIN Function includes numbers that are zero. A simple way around this is to combine to functions together into one formula. SMALL and COUNTIF.

So, to recalculate the minimum excluding zeros would be written like so:

=SMALL(A1:A200,COUNTIF($A$1:$A$200,0)+1)

You can also combine the MIN Function with the SUBTOTAL Function.

I hope you found this post on Excel’s MIN Function useful.

Leave a Reply

Your email address will not be published. Required fields are marked *