Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

In this lesson, I’m going to be showing you how to:

  • Use the Min function to find the smallest value from a range of numbers
  • Use the Max function to find the largest value from a range of numbers

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Or go back to:

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

62 thoughts on “Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel”

  1. Hi Habib, after watching your previous lesson 5 about the average function, i had to keep going to learn the other stuff in excel and once again, you did not dissapoint. Thank you and keep up the good job.
    Regards
    Janet

    Reply
  2. Hi Habib,

    Another down to earth easy to follow tutorial on the min and max functions. As it turns out, I use excel regularly and I’m quite conversant with these functions. However, there are times when I have to show new members in my team how to use these functions and this module is something I’d be happy to recommend.

    Great job.

    Cheers
    Femi

    Reply
  3. Thanks to you, my son thinks I am a super-woman. He needed to learn MIN and MAX features IN Excel and I surprised him by knowing it all. I love the internet. Everything is at our finger-tips.
    🙂

    Reply
  4. Hey Habib,

    I quite enjoyed this lesson on the MIN and MAX functions in Excel. They are very convenient functions indeed!

    Thank you for explaining that blank cells or cells that contain text will not count towards working out the MIN and MAX values. I am one of those people that thought that a value of 0 would be returned in those instances but I now know that is not the case.

    Thank you for another great lesson. 🙂

    Reply
  5. This is very wise to learn while habib is showing us and taking the time to formulate the actual events. Learning how to do mean average and median and min & max functions in excel. In school, we are learning about how to do the average on excel and this is even more helpful to us.
    Looking forward to the next articles

    Cheers,
    Mathew&Deloris

    Reply
  6. Hi Habib,

    To be honest, I don’t know this formula for my excel reports, so it’s good to learn new formulas to upgrade my excel skill level.

    By your tutorial of MIN & MAX, I don’t need to compare the numbers with my eyes but a faster & correct formula to pick up the minimum & maximum numbers from months. So, my manager and our team can discuss the implementation we can take for more earning potentials.

    Thanks for sharing today. You are helping me sharpen my excel and complete my jobs quicker to have more time for important things.

    Cheers,
    Matt

    Reply
    • You’re very welcome Matt – I’m very happy to hear that you have or will be implementing this skill of MIN and MAX function taught in this lesson.
      Many more lessons are coming for you to learn about many more functions in excel.

      Habib (ICT tutor)

      Reply
  7. Thank you very much for your tutorial
    Although I had never used min and max functions I will start incorporating in my excel sheet as I may need these values in the future.
    Does this work on all excel versions?

    Reply
    • You’re very welcome Thabo. Yes, the MIN and MAX function have been around for years and should work on all versions of excel.

      Habib (ICT tutor)

      Reply
  8. Finally, I found a tutor that I can rely on. A friend of mine recommended your site, and I can’t thank him enough for it.

    I also subscribed to your YouTube channel, and it’s nothing short of amazing. Thank you for this tutorial. It helped me a lot, and I learned a ton of valuable information from it.

    Until next time! I wish you all the best bud…

    Reply
    • Hi Gorjan,

      That’s fantastic to know! I’m glad you have found the right learning and learning style for yourself.

      You are welcome and keep going with your learning.

      All the best

      Habib (ICT Tutor)

      Reply
  9. Hey Habib,

    The MIN and MAX functions in Excel are very cool! I can see how they would be valuable functions to utilize, especially with large spreadsheets.

    I also find it cool how Excel ignores blank cells when calculating MIN and MAX values. Thank you for explaining that as I would have assumed that 0 values would have been returned in blank cells.

    Thank you for yet another great lesson!

    Reply
    • You’re very welcome Michael – you are not alone there, many of my own students thought the MIN function would identify the blank cells as a zero and return as the answer. This is why I had to make this very clear for everyone’s understanding. Take care 🙂

      Habib (ICT tutor)

      Reply
  10. Hey Habib! I consider myself to be computer literate and pretty well-versed in Microsoft Office. But Excel has always been the toughest program to get a hang of, especially due to the formulas and functions.
    Your tutorial makes it easy to follow and very practical, though. I’ll be referring to this periodically when working on my sheets! Thanks!

    Reply
  11. I have used Excel for my entire career.
    And, I became worried to say that I know Excel as I learned more functions of it.

    There are so many Excel functions I am not familiar with.
    It is such a great tool and highly useful for many professionals and average users.
    It looks like your are an expert in Excel, and teaching many useful Excel functions will help many users online.
    Thank you for providing an easy-to-follow tutorial, and I look forward to learning more useful functions from you.
    Thank you.

    Reply
    • You are right Rob, there is so much that can be learned in Excel. I try my best to make the tutorials as simple as possible whilst delivering the aims of the lessons.

      All the best

      Habib (ICT Tutor)

      Reply
  12. Thank you so much for this comprehensive lesson. I wish I knew about you back when I was at school. It would have been useful for my math classes.

    Reply
    • Awww… Lol My adult students say the same too!

      I try to make my teaching as user friendly as possible. Glad to know it’s been helpful for you.

      Best Regards

      Habib (ICT Tutor)

      Reply
  13. Excel can be a very daunting application for some and you don’t need to know about the functions in order to use it but knowing just a few of these functions can improve productivity no-end.

    Now all I do when I am thinking about a function that I might want to use, I just click on your site and its there in plain sight.

    Thank you for sharing.

    Reply
  14. Thanks for another effective tutorial to make excel easier for people to follow. I’ve only ever been able to use excel at its most basic level, but I’m getting better through watching these tutorials. They are very useful.

    Reply
  15. Hi Habib,
    Great post. Thanks for adding another knowledge (min and max) concepts to my excel knowledge bank. Among all the Youtube tutorials on excel that I have watched, this is by far the best.
    Thanks for sharing.

    Reply
    • Thank you Benson – you are our regular visitor and we are always very happy to receive your comments and feedback. I’m happy you found the minimum and maximum functions very useful. Take care 🙂

      Habib (ICT tutor)

      Reply
  16. Hi Habib,

    Thank you ever so much, not only for this video, but your entire series thus far.

    I’m not sure why excel has always been a bit of a struggle for me, as your explanations make perfect sense, and to be honest there isn’t anything particularly complicated in the various formulas you provide.

    Having to work constantly with producing excel spreadsheets and the like, it’s actually a pleasure to find all the information required in one place, and without any use of jargon or complicating matters.

    Thanks once again and keep up the great work.
    Partha

    Reply
    • Hi Partha,

      Thank you for your extensive feedback. I’m humbled to know how useful these tutorials been for you. I tried my best to keep it as simple and user friendly as possible. So, even for someone who is new to spreadsheets can learn from it.

      Please keep visiting our site more more useful contents like these at: https://lifestyletipsandhacks.com/

      Best Wishes
      Habib

      Reply
  17. Im realy enjoying these tutorials. I like it how you put the real world into your explanations. It makes us see reality and picture how excel is used in the outside world.

    Reply
  18. Another very practical video. They are simple functions but very much used. It makes so much easier. Excel is a fantastic tool. I’m exploring each day more and more. I’m using the function SUMIF and COUNT a lot this days. It helps me to keep my spreadsheet updated without effort. Thank you for all the tips and all the best.

    Reply
    • Happy to hear you’re exploring excel, it will most definitely make your life a lot easier and efficient because most of the tasks, excel will do for you and update automatically when you make any changes to your data.

      I will be creating a video tutorial in the future for the SUMIF function, so come back and check or subscribe to my YouTube channel and you will be alerted automatically: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg

      Reply
  19. Thank you for the lessons on functions. They can be quite challenging but you have explained how to do them really well in your videos.

    Reply
    • You are welcome. Yes functions can be challenging – but like you said if they are well explained and demonstrated, then they are actually very easy to understand and apply in Excel. All the best

      Habib (ICT Tutor)

      Reply
  20. Hi, many thanks for useful information. You have explained it logically for me so I am gonna have a look on your other lessons as well.

    Reply
  21. Hey Habib,

    I believe this post will definitely help many people. In one of my earlier jobs, I had to struggle with excel a lot and I learned everything by either reading blogs or watching videos.
    Sometimes, it takes a lot of time to find the correct resource to learn even a simple task like this in the correct way. Especially for non IT guys and those who do not have any related background, these could be more important than many of us think.

    Thank you for taking time to explain clearly.

    Reply
    • Hey Rajith, a lot of people struggle with Excel, but never find the right site or the right help, this is why I have and continuing to create these video tutorials, so that people who visit my site will keep returning to take advantage of my knowledge and skills of the Microsoft Office applications.

      My videos are simple, with good explanations of the functions before I demonstrate how to implement each skill. Knowledge is the key. Thank you

      Habib (ICT Tutor)

      Reply
  22. I have used Excel for a while.
    By the way, I became hesitant to say that I know Excel as I learned more functions of it. There are so many Excel functions I am not familiar with.
    Some people say that the world will be different once someone gets familiar with Excel. It is such a powerful tool and highly useful for many professionals and average users.
    You seem to be an expert in Excel, and teaching many useful Excel functions will benefit many online users.
    Thank you for providing an easy-to-follow tutorial, and I look forward to learning more useful functions from you.
    Thank you.

    Reply
    • Thank you Jason for your detailed comment. Yes you are right, Microsoft Excel is very logical and I am a logical person I guess. lol.

      I highly recommend it to everyone regardless of their profession and role. You will always take away something from my tutorials.

      Many Thanks
      Habib

      Reply
  23. Hi there,

    Thank you so much for the tutorial in utilizing fx insert, minimum and maximum function using Microsoft Excel. This is one of the skills that I am lacking on. The other day LinkedIn asked me to update my skills info, I was hesitating about putting down Microsoft Excel. So, thank you for this tutorial. I will definitely check out your previous lessons as well. Once I have mastered Excel, I’ll update my skill info on LinkedIn.

    Reply
  24. Thank you for this information, I’m going to need to start learning how to use Excel now and this is a great starting tool. Thank you again.

    Reply
  25. Exactly what I was looking for. I need to go back to the previous lessons to put it all in order. I enjoy working with Excel and the more I can learn, the more proficient I can become. Thank you for doing this is video form so I could see the live action.

    Reply
    • You’re welcome Greg. Video tutorials are the best. I started doing these tutorials with my students in mind during this Covid lockdown, but it seems everyone is benefiting – so for that, I am more than happy to do more video tutorials.

      Reply
  26. Hi Habib,

    Thanks a lot for providing this excel lesson regarding minimum & maximum. I learned excel in university, but that was 10 years ago, and now I need to be using it in my job. I really needed a refresher, so your lessons have really been helpful, and they are really clear and easy to understand!

    Reply
    • Hi Fernanda, glad to hear the lesson was clear and easy to understand – I get this a lot from my students. We always need a refresher, especially if it is 10 years ago. I hope your job will be easier now after going through my lesson. Take care

      Reply
    • You’re welcome and thank you Christy. Functions can be very challenging if not understood correctly. My aim is to simplify the learning for everyone.

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap