Bob Phillips wrote:
Hi Frank,

Missed that subtle nuance. INDEX(MATCH?


Yeah
I tried that but the result is even more complicated than the OP's
solution. I only got to this non array solution:
=SUMPRODUCT((ABS(range)=MAX(ABS(range)))*(range))
not simpler but a non array one :-)

Frank