To use the MAX or MIN functions in Excel, follow these steps:
- Open your Excel file and type your data
- Press ALT + F11 to open the Microsoft Visual Basic Editor
- Create the MAX or MIN function in the corresponding coding window
- Type the required cell headings in the function
- Click RUN to execute the function
- Check the column where you have added the function and verify that it worked as expected.