One Minute To Better Excel Functions: MAXes


Uncle MAX.  Around the punch bowl a bit too much?  Perhaps.  But always there when you need him--and he finds ways of being useful when least expected!  Don't forget about Uncle MAX.

As the video shows, we can call on the great MAXimillian in a few different ways.

EQUALS, "="

I only mention it because, well, so many good citizens think they need to press the little f(x) button near the function command line.  Nah, just start typing in the cell starting with "=".

Meh

Of course, we could select each cell once we have our MAX() function:

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

Better

A bit better (faster I suppose) to select a range:

=MAX(K13:K17)

Best!

Noticing a trend with these blog posts?  Resilience is king!  And it makes our spreadsheet more resilient to changes if we select the whole column.

=MAX(K:K)

Should you need help with any of these concepts, we're just a phone call away!  Rather than spend your time trying to become an Excel expert, we can fix it for you in minutes!  Give Spreadsheet Sherpa a jingle at 877.851.0132 today.