Question: how to create a formula using max function in excel?
Answer: Press Enter key, the max data will be selected in the cell. ... 
In this way, it can only get one max data, and moreover, it can't specify the data's location. ... 
Select the range you want to work with from in the popup dialog.