How to Show Lowest Number in Range of Cells

auto-min

A quick way to get and show the lowest number in a range of cells, instead of using the  =MIN function by hand, is to use the auto min button in excel.

  All you do is click in the cell directly beneath the last cell in the range with numerical data (in the image this is cell E8). Then click the auto sum button, which looks like a 3 backwards.  Then select Min, and Excel will then automatically select the range for you, make sure the selection is correct (if it isn’t then simply adjust by dragging with the mouse), then hit enter!  The cell should now show the lowest number in that range!  In this instance it is 2.

Leave a Reply

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