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
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Removing Add-ins
- Downloads by category
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Contour plots with Excel and Matplotlib
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
Tag Archives: Array Formulas
Extracting selected data with array functions.
This post is in response to a query at the Eng-tips forum asking how to extract selected data from a range, so that the three best scores for each individual could be extracted from a two column Excel table listing multiple individuals, … Continue reading
Using Array Formulas
Many of my User Defined Functions (UDFs) return an array of values, that requires a special procedure to make all the values visible. I have usually given a brief description of the procedure with the UDF, but for convenience for … Continue reading
Finding Prime Numbers with Excel, and using Array Formulas
Download Primes.zip. Several of the puzzles at Project Euler (see previous post) require the finding of prime numbers, for instance what is the 10,001th prime number? Searching the Web for some ready made solutions I found this array formula at … Continue reading
Posted in Arrays, Excel, Maths, Newton, UDFs, VBA
Tagged Array Formulas, Excel, Marths, Prime Numbers, UDF
27 Comments