Recent Comments
Category Archives: Arrays
Repeating a set of data
The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data. I have written a simple UDF to do this job, and also extract … Continue reading
Solving simultaneous equations – Fortran dll
The file simultaneous.zip has been modified to allow access to a Fortran simultaneous equation routine, compiled as a dll. The original file was posted in solving simultaneous equations. The advantages of a compiled routine include: Much better performance Greater precision through … Continue reading
Posted in Arrays, Fortran, Link to dll, Maths, UDFs, VBA
Tagged dll, Excel, Fortran, Simultaneous equations, UDF, VBA
3 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 Array Formulas, Excel, Marths, Prime Numbers, UDF
28 Comments
Linking Excel to C – 3; Avoiding bottlenecks
The previous post in this series included a C dll to solve cubic polynomial equations that could be called from VBA. The performance of this routine is compared with a VBA routine using a similar algorithm in the sceenshot below (rows … Continue reading
Posted in Arrays, Excel, Link to dll, UDFs, VBA
Tagged C++, dll, Excel, Visual Studio C++ Express
2 Comments
Solving simultaneous equations
Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis. Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading
Newton Excel Bach, not (just) an Excel Blog 