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’]

You can download a file here to practise on.