Tag Archives: MaxAbs function

Two MaxAbs functions

Excel does not have a built-in function to find the maximum absolute value of a range, perhaps because the Max() and Abs() functions can be combined in an array function: =Max(Abs(datarange)) This solution has a number of drawbacks however: The … Continue reading

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 9 Comments