Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
- Using Goal Seek on Multiple Cells
- Taming Symbols in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Two New Functions; Let and Lambda
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
Recent Comments
Lambda and VBA | New… on Two New Functions; Let and… dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a…
Tag Archives: maximum absolute value
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