Exclude a figure from a MAX function

[Beckie_001]

Hello,

I have a list of ages (in months) that has been generated by a formula. I am trying to find the maximum age in the cohort, but because of the forumla it's pulling through those burrently blank lines as the forumla answer defaults to 1375. Is there any way to do the Max function of anything <1375?

 

[snb_]

arrayformula:

=Max((A1:A100<1375)*(A1:A100))

 

[RoryA]

Or change the age formula so it returns "" instead of 1375.

 

[Beckie_001]

So simple, but genius! Thank you for your help

Beckie