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.
2014 World Cup Spreadsheet With the draw for the Brazil 2014 Soccer World Cup over, we have updated our 2014 World Cup Spreadsheet. As with the other prediction spreadsheets we have created for sport events, you will be able to … Continue reading
Excel round to nearest 1000 Most people are aware of how to use the ROUND functions to round numbers to various decimal levels e.g. 5.5678 to either 5.568 or 5.57 or 5.6 or 6 depending on what you specify the … 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