Your solution would answer a different question.
Thank you for the idea.



"Alan Beban" wrote:

Not on my machine.

Alan Beban

Jim Aksel wrote:
Half way there. That works to find the largest negative value.
I tried the ARRAY formula
=MIN(IF(A1:A1000,A1:A100))
Using this formula provides the same value as =MIN(A1:A100)