How to find Max from range of Positive and Negative Numbers?

[weemeng]

Hi Gioka,

Another problem, If I expand your formula to compute
multiple rows. I got a result of #N/A by using your
formula. This is what I do, after naming the cells A1 to
E2 as "YourRange" & enter formula
=INDEX(YourRange,MATCH(MAX(ABS(YourRange)),ABS
(YourRange),0)) and use Ctrl+Shift+Enter to enter the
formula. I got a result of #N/A.

See eg below, I need Excel to return -200. Can you help
on this?

A B C D E
1 100 -200 -10 -20 40
2 300 -100 50 80 60

Can any one help on this?

Regards
Wee Meng

 

[weemeng]

-----Original Message-----
Hi Gioka,

Another problem, If I expand your formula to compute
multiple rows. I got a result of #N/A by using your
formula. This is what I do, after naming the cells A1 to
E2 as "YourRange" & enter formula
=INDEX(YourRange,MATCH(MAX(ABS(YourRange)),ABS
(YourRange),0)) and use Ctrl+Shift+Enter to enter the
formula. I got a result of #N/A.

See eg below, I need Excel to return -200. Can you help
on this?

A B C D E
1 100 -200 -10 -20 40
2 20 -100 50 80 60

Can any one help on this?

Regards
Wee Meng



.

 

[Eleni Gioka]

Try my answer at the question you posted at 4:31.
I think this is the answer to your problem.

E.G.