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.
![CALLIGRAPHY ON IPAD TABLET [Arabic script on an abstract background]](https://images.videosashka.com/watch/Uu6CVlzLGhA)
