Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automatic download of csv files
- Latex Maths Text in Excel
- Retrieving unique values from a range or array ...
- Cubic Splines
- Contour plots with Excel and Matplotlib
- 3D Matplotlib Plots in Excel
- About Newton Excel Bach
Recent Comments
Tag Archives: Marths
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
28 Comments