# Maximum of absolute values within a range in one step

This is a discussion on Maximum of absolute values within a range in one step within the Excel Questions forums, part of the Question Forums category; Greetings all. I have a range (column) of data, say A1:A20. Now, I would like to return the maximum of ...

1. ## Maximum of absolute values within a range in one step

Greetings all.

I have a range (column) of data, say A1:A20.

Now, I would like to return the maximum of the absolute values for the numbers found in these cells. I can get this in 2 steps, but can someone come up with a way to combine this into one formula? My solution would be to create a 2nd column with the absolute values and then add a cell which pulls the max for that range.

Any thoughts on a one-step solution would be greatly appreciated.

Regards,

Sean

2. ## Re: Maximum of absolute values within a range in one step

=MAX(INDEX(ABS(A1:A20),0,1))

3. ## Re: Maximum of absolute values within a range in one step

Thanks Aladin. As usual, that was perfect.

Sean

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•