Finding maximum value

R

Ruan

Hello,

I want to find the maximum value in a column, but I want to ignore the
negative and positive part of the value. Basically, the maximum difference
from zero.

Example: the maximum value I am looking for will be -0.467.
-0.467
0.345
-0.253
0.411

Thanks
Ruan
 
J

JE McGimpsey

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=INDEX(A1:A4,MATCH(MAX(ABS(A1:A4)),ABS(A1:A4),FALSE))
 
Top