- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Installing Adobe Reader non-DC version.
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Lateral pile analyis with PY curves ...
vgmendes on LinEstGap with non-linear… dougaj4 on LinEstGap with non-linear… vgmendes on LinEstGap with non-linear… Stan on ALGLIB linear and polynomial f… dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… GP on Weighted Least Squares Regress… Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update angelgalvanc on 3D Frame Update
Tag Archives: VLookup
Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup on a large amount of data without taking all day, but still retaining the ability to return … Continue reading
The Excel Lookup functions (including VLookup, HLookup and Match) all allow for an “exact” or “closest” match on numerical data, but the closest option has a number of problems: The data must be sorted For VLookup and HLookup the data … Continue reading