Finding maximum value

[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

 

[JE McGimpsey]

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

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

 

[Ruan]

Thanks that worked great.

Does excel allow for arrays in Conditional Formatting?

Ruan

 

[JE McGimpsey]

Unfortunately, no.