Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Intersections, interpolations, and rotations
- Continuous beam animations with VBA and Python
- Using Excel's shortest functions
- Buckling of columns with varying cross section
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- Biaxial bending update
Recent Comments
Tag Archives: fast lookup
Time to Lookup
At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Exact lookup, Excel, fast lookup, precise timer, UDF, VBA, VLookup
5 Comments