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

  • Thread starter Thread starter weemeng
  • Start date Start date
W

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



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

E.G.
 
Back
Top