Tag Archives: Array Formulas

Extracting selected data with array functions.

Posted on June 16, 2012 by dougaj4

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

Posted on May 10, 2011 by dougaj4

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

Posted on November 18, 2008 by dougaj4

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