Good day everyone,

On An Excel sheet, I have a column filled with account numbers. In cell E1,
I have the following formula:
=LARGE($AC$2:$AC$65536,1)

Which gives me the highest number in the column. However, I 'd like to have
for result the highest number as long as this number is lower than 200,000

Would anyone know how to write the formula?

Thanks for your time

Denys