Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- Downloads by category
- Using conditional formatting with array formulas
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- P-Y Curve function
Recent Comments
Tag Archives: EqualT
Comparing floating point numbers
Some of the issues raised in this post: https://newtonexcelbach.wordpress.com/2011/12/20/when-does-35-not-equal-35/ arose when writing the functions for the previous post on combining arrays. In particular, when values from the two arrays are “equal” the function should create one entry in the combined … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Combinearray, EqualT, Excel, floating point comparison, UDF, VBA
4 Comments