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

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

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 , , , , | 27 Comments