Finding maximum value

  • Thread starter Thread starter Ruan
  • Start date Start date
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
 
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

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