One Minute To Better Excel Functions: MINs


Minimums aren't always bad.  Sometimes less is more, right?  Golf.  Airplane seats.  Hot sauce.

Excel gives us an easy way of figuring out the minimums of data sets:  the MIN() function.  Here are some options for using it.  Of course, we always begin with...

EQUALS, "="

This is how we tell a cell what to do, who to be, what to show.  Click on the cell and type equals.  Simple!  Now how do we find the minimum of Column K?

Meh

I suppose one way to find the minimum would be to type "=MIN(" then hold down CTRL and select each of the cells:

=MIN(K13,K14,K15,K16,K17)

Better

Much better, of course, is dragging the mouse across the whole range for which we want to find the minimum:

=MIN(K13:K17)

Best!

But what if we add all the NFL Quarterbacks in 20+ more rows?  Let's use a formula that will stand the test of time no matter how many rows we add:

=MIN(K:K)

Rather than spend your time trying to become an Excel expert, we can fix it for you in minutes!  Excel help is just a phone call away.  Ring Spreadsheet Sherpa at 877.851.0132 today.