Finding the highest value dynamically
Finding the highest value dynamically
To find the highest value, we use the MAX function.
The range is open-ended.
To find the position of the highest value, we use the MATCH function.
The INDEX returns the entire row by setting the column index to 0.