I have a file where I track work order numbers. They are assigned a tracking number by area 1XXXX for area 1, 2XXXX for area 2, etc. I have the top of the sheet frozen so I can see the lates number assigned by area but I am currently updating that manually. Is there a way to have excel look at the list of all work orders and display the max between 10000 and 19999?

Thank you for your help!