### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Scipy linear algebra functions in Excel
- Cubic Splines
- Latex Maths Text in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LinEst() on data with gaps
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Section Properties of Defined Shapes - Spreadsheet
- Commenting a block of code in VBA

### Recent Comments

# Tag Archives: Prime Numbers

## Daily Download 26: Moving averages and prime numbers

Today’s downloads are the last of the maths related functions: http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified … 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