Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Beam actions and deflections by Macaulay's Method
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Downloads by category
- Using Goal Seek on Multiple Cells
Recent Comments
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