Finding Max number within a specific range of numbers

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!

*latest (just a correction)

I'm thinking =LARGE(IF( "number from list" <20000),1)

but i don't know how to input the number from the list as a whole array of numbers. This would be for area 1 by the way ^

Another problem is I wouldn't know what to use for the values if it fails or passes the logic test...

See formula below. I used A4:A20 as my sample range of test data, so you will just need to adjust that based on your actual range.

=MAX(IF(LEFT(A4:A20,1)="1",A4:A20))

Enter this formula as an array by using Ctrl+Shift+Enter rather than just Enter. It will look like this if you've entered it correctly (notice the extra brackets):

{=MAX(IF(LEFT(A4:A20,1)="1",A4:A20))}

This matches the left character from the tracking number from whichever group you want to pull the max number. The formula for the tracking numbers starting with "2" will look like this:

{=MAX(IF(LEFT(A4:A20,1)="2",A4:A20))}

Hope this helps.

Thank you, That worked perfectly!

Hi can't get the problem. can anyone provide me the sample sheet so that i can understand this please.

Thanks.
Perpectuals

Attached is the sample workbook that I used.