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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top