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