Highest ABS in Range

[erock24]

This should be easy but I'm having trouble.
How can I pull the highest absolute value out of a range?
Thanks for your time and help.

 

[Oorang]

The highest ABS in a range is going to be the same as =ABS(MAX(A:A)) because there is no scenario where the results will differ if you apply abs to each number then max, or vice versa.

 

[Jonmo1]

=MAX(ABS(A1:A5))

entered as an array with CTRL + SHIFT + ENTER

 

[Jonmo1]

The highest ABS in a range is going to be the same as =ABS(MAX(A:A)) because there is no scenario where the results will differ if you apply abs to each number then max, or vice versa.

Not True

personal.xls
	A	B	C	D
1	1	9	8
2	-5
3	2
4	8
5	-9
Sheet1

 

[facethegod]

Try this fill in Range with the range needed. Confirm with Ctrl + Shift +Enter, not just enter

=INDEX(Range,MATCH(MAX(ABS(Range)),ABS(Range),0),1)

 

[erock24]

Jonmo1

thanks. I always forget about ctrl+shift+enter. Works perfect. Also, it turns out I had an #N/A deep within my range, so that was messing things up as well.

0orang,

Your formula only returns the highest value of the positive numbers.

Thank you all for your time and help.

 

[Oorang]

Forgot about negatives

 

[Paddy1979]

Try..

=MAX(ABS(IF(ISNUMBER($A$2:$A$11),$A$2:$A$11)))

with ctrl - sh - ent