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!
How to use the Excel Maximum and Minimum functions to find the maximum or minimum of a range
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.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
The date format of MMDDYYYY is a potential problem for many people the world round. The main reason for this is that most people don’t understand how Excel handles dates. But first the background. Who uses MMDDYYYY Per Wikipedia the … Continue reading
The recent Marks & Spencer spreadsheet blunder will inevitably lead to more questions about the use of spreadsheets. In this podcast from the Financial Times, Lisa Pollack reports on the latest attempts to make spreadsheets more formal and professional. Listen to the … Continue reading
Just a quick note to say your blog is brilliant. Full of useful bits of info. After your courses, I am by far the best modeller in our office, and we regularly get comments from our business partners on the quality of our models. Thanks for all the help,– Mike