Using Max function – (Excel 2007/2010)
The max function (Excel) allows you to find the highest value in a list.
View the video to see how to do it in Excel 2007/2010
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/04_max_demo.m4v’]