In the destination cell enter =MAX( then go to the source sheet and select the range. Add the closing parenthesis. XL adds all that is needed by itself

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post