I know exactly what you are talking about, unkpath. You can find some limited examples of this at http://test.tukhi.com/
. After installing you can run (Alt-F8) the macro SIEVE.DEMO to compute the Sieve of Eratosthenes. Change B5 to 30,000 and hit the two pip die to compute primes up to 30,000. Right click in B14 and chose Adjust from the cell menu.To get documentation, choose Tukhi|Help from the Excel menu and see the Array section in the help file.I spent 3 years at Morgan Stanley writing A+ code and have implemented many of the array functions in that language. The latest evolution of A+ is kdb by kx systems. If you know C++ you can roll your own using the library for creating xll's at http://kalx.net/xll
. See ARRAY.UNIQUE in example.cpp in the example project for the basic technique.