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!
As per our financial modelling course we highly recommend that negative numbers are clearly shown as such and we prefer brackets around a negative number and that the negative numbers are in red. There are several options to achieve this … Continue reading
One of the most common formatting requests is how to get Excel negative numbers in brackets (and red) instead of just a negative sign (-) in front of the number. The actual issue is not an Excel issue but rather at … Continue reading
"Adrian and Team. Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude towards De Wet, who hosted the Excel Advanced course.– Gill Robbetze Lonmin