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

Posted in Arrays, Excel | Tagged , | 5 Comments

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

Posted in Arrays, Excel, UDFs | Tagged , , | 20 Comments

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