Max absolute value comand?? 3

• Dec 17, 2003

• #2

joerd

Chemical

Sep 27, 2002

531

Type

Code:

=MAX(ABS(A1:A4))

and press Ctrl+Enter (enters it as an array formula). The formula now looks like:

Code:

{=MAX(ABS(A1:A4))}

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

Upvote 0 Downvote

• Dec 17, 2003

• Thread starter
• #3

SRO

Structural

Dec 27, 2001

104

joerd:

Thanks, but the problem is that the values arn't in the same column or row.

 

Upvote 0 Downvote

• Dec 17, 2003

• #4

jproj

Chemical

Oct 9, 2001

324

Just separate the values with comma's:

=MAX(ABS(A1),ABS(B4),ABS(E19),....)

jproj

 

Upvote 0 Downvote

• Dec 17, 2003

• #5

joerd

Chemical

Sep 27, 2002

531

Unfortunately, you cannot use =MAX(ABS(A1,D9,F7,E12)) and select the cells holding the Ctrl key, what you would normally do. I see nothing quicker than =MAX(ABS(A1),ABS(D9),ABS(F7),ABS(E12)) unless you venture into a VBA function, which will look something like:

Code:

Function MaxAbs(ParamArray R() As Variant)
Dim C As Variant, V As Double

    V = 0
    For Each C In R
        If Abs(C.Value) > V Then V = Abs(C.Value)
    Next C
    MaxAbs = V
End Function

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

Upvote 0 Downvote

• Dec 17, 2003

• #6

melone

Electrical

Aug 10, 2001

1,233

Or make a table of the desired values....

 

Upvote 0 Downvote

• Dec 17, 2003

• Thread starter
• #7

SRO

Structural

Dec 27, 2001

104

Thanks for all the input, I was just hoping there would be a simple comand. Thanks.

 

Upvote 0 Downvote

• Dec 17, 2003

3
• #8

needahandle

Mechanical

Aug 25, 2003

19

Try combining Min and Max;

=MAX(MAX(A1:A4),-MIN(A1:A4))

 

Upvote 0 Downvote

• Dec 17, 2003

• #9

bltseattle

Civil/Environmental

Sep 18, 2002

347

I like needahandle's solution. Nicely done!

 

Upvote 0 Downvote