Hi all

I am looking for a formula which will return the highest value in a list, below 400

So, if the list were

1
2
3
4
5
6
401
402
403
501

The returned value should read six.
The list could be randomly long, so the highest value might be 2 or 50

Any suggestions on this?

Thx
FD