you could use the filter and the subtotal command
select column ac
click data/filter/ auto filter
click the arrow
select custom, is less than or equal to and enter 200000
then use the subtotal function

=SUBTOTAL(4,AC2:AC65535)

--


Gary


"Denys" wrote in message
...
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