Results 1 to 3 of 3

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. #1
    Board Regular EconSean's Avatar
    Join Date
    Apr 2002
    Location
    Philadelphia, PA
    Posts
    129

    Default 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. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,996

    Default Re: Maximum of absolute values within a range in one step

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

  3. #3
    Board Regular EconSean's Avatar
    Join Date
    Apr 2002
    Location
    Philadelphia, PA
    Posts
    129

    Default Re: Maximum of absolute values within a range in one step

    Thanks Aladin. As usual, that was perfect.

    Sean

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com