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.
Advanced Excel and Financial Modeling Training in July and August 2013 Over the next 2 months we will be running a number of Excel related courses. In particular we will be covering Advanced Excel and Financial Modeling training. The dates … Continue reading
Sheet Navigation in Excel 2013 Sheet navigation in Excel 2013 is slightly changed and on initial viewing you may wonder where some of the buttons have gone. In particular, you might want to know how you get to the very … Continue reading
AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.– Sasol Polymers