Next Live Training Date:

JHB:6-10 June, Cape Town:13-15 June

Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!

Excel Maximum and Minimum

Excel Maximum and Minimum
Watch this video

How to use the Excel Maximum and Minimum functions to find the maximum or minimum of a range

  • 1:26
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Excel Maximum and Minimum formula

In this segment you will learn how to find and activate the Excel Maximum and Minimum functions, and how to use the functions to limit a cells content to a maximum or minimum amount.

In this example we have a list of Players and four Scores for each player. We have the Average, what we’d like to do is automatically work out what the maximum score is and the minimum score for each player. To do this

In order to determine the minimum number,

We can now copy these formulas all the way across, and quickly work out what each players average maximum and minimum score was.

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

Advanced Excel Course in Cape Town Venue

For the upcoming Advanced Excel Course in Cape Town, we can confirm that the venue is going to be the Rockwell Hotel. The venue has rooms as well so if you need accommodation while on the course, they can arrange it. … Continue reading

Sweepstakes Kit for Euro 2016

If you are thinking of running a sweepstakes, and want to find a sweepstakes kit for Euro 2016 you can do one of 2 things: Run a simple paper based sweepstakes, or Run a Euro 2016 score prediction sweepstakes, which … Continue reading

Your (AuditExcel) Advance Excel and Financial Modeling course is one of the best courses available on the market, it is well structured, relevant and insightful. I will recommend it to anyone who would like to improve his/her Excel and/or Financial Modeling skills.

– Namibia

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients