### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Taming Symbols in Excel
- Using LINEST for non-linear curve fitting
- Downloads by category
- P-Y Curve function
- Cubic Splines
- The angle between two vectors, Python version
- Fitting high order polynomials

### Recent Comments

# 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

## 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

## 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