Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Maximum of absolute values within a range in one step

  1. #1
    Board Regular EconSean's Avatar
    Join Date
    Apr 2002
    Location
    Philadelphia, PA
    Posts
    129
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    80,731
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Thanks Aladin. As usual, that was perfect.

    Sean

User Tag List

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