How to use MIN and MAX functions in Excel

How to use MIN and MAX functions in Excel

This Friday I have 3 new Excel tips & tricks to take your skills to the next level. We cover the Select All button you maybe never knew existed, Shift+Space shortcut and functions MIN and MAX, MINIFS and MAXIFS.

A useful Excel tip:

To select all the data on the current sheet in Excel, click on the small square at the top left of the sheet between row 1 and column A. You can also use the Ctrl + A keyboard shortcut.

To select all the data on the current sheet in Excel, click on the small square at the top left


A shortcut you can use to speed up your Excel use:

Use the Shift + Spacebar shortcut to select the entire row of the currently selected sheet in Excel. It’s quicker than using the mouse.

A function you can use next week:

Two easy functions this week - MIN and MAX. Use MIN to find the minimum value or earliest date in a list, and MAX to find the highest value or latest date in your data. They both just have a single component - the range you wish to refer to, so for a range in A1:A100, just type =MIN(A1:A100).

If you have Excel 2016 onwards of Office 365, there’s a more useful version of these functions called MAXIFS and MINIFS, which allow you to find the MAX or MIN values depending on criteria you set. To find the minimum value in column A where Column B = “Red”, for example, type =MINIFS(A:A,B:B,”Red”).

There are several ways to calculate the smallest or largest number in a range and you can read more here!

As always, I hope these tips help you take your Excel skills up to the next level in 2019, one week at a time! Please let me know if you have any suggestions or requests for future tips.

Martyn

February 2019