TOP EXCEL WEB SITES
For the best in 3D add-in functionality, check out:
http://perso.wanadoo.fr/longre/excel/pages/Downloads.htm
http://xcell05.free.fr/
Also, check out the freeware file Make Excel 3D in the CompuServe Excel
forum library for a comprehensive set of 3D custom functions.
Editor’s Note: I’ve never used MOREFUNC.XLL, but I’ve heard a lot of good things about it. Other than the Analysis ToolPack ToolPak, I rarely use add-ins that provide additional worksheet functions. I don’t know why, really. I guess I’m concerned that it makes the spreadsheet less portable. Anyway, if you have good or bad experiences with this one, be sure to leave a comment.
Great plugin ! VERY useful functions.
But homepage didn’t work ((
I wonder why some topics get 100’s of responses, and other equally worthy ones get one response after 2 1/2 years.
Anyway, I tend to only use UDFs I’ve written myself; I don’t know why really. I have morefunc, it looks really good, and one of these days I’m going to spend some time finding out which of its functions will be really useful to me.
People prefer responding to problems, at least those of us who solve problems for a living.
Anyway, what’s useful in MOREFUNC?
THREED — the best udf so far for working with 3D references as arrays (though stacked 2D arrays)
*.EXT — extensions of statistical functions that handle either much larger ranges/arrays or provide
much better numerical behavior
REGEX.* — regular expression text functions
There are some other handy functions, but there are usually either faster built-in function equivalents (ROW vs INTVECTOR) or they could be implemented fairly simply in VBA. One of the functions, MCONCAT, is much less useful implemented in an XLL than a VBA module because the XLL interface limits returned strings to 255 characters while VBA can return 32767 characters.