Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- Cubic Splines
- Retrieving unique values from a range or array ...
- A catenary function
- The history of the theory of beam bending - Part 3
- Writing Arrays to the worksheet - VBA function
- Converting from global to local coordinates (and vice versa)
- Linestgap with data in rows
Recent Comments
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 Excel, MaxAbs function, maximum absolute value, UDF, VBA
9 Comments