Whenever I see solutions in MS Excel without the use of VBA it actually reveals the core power with functions and formulas. That’s why I want to highlight the excellent work made up at “E90E50fx….only formulas”.
It says “…only formulas” however it exist at least one article that includes VBA. But they are forgiven 🙂
The following link will take You to the site:Â https://sites.google.com/site/e90e50fx/home
Now I will go back to other activities excluding MS Excel!
Enjoy!
Kind regards,
Dennis
VSTO & .NET & Excel 
Hi Dennis. If you like formulas, no doubt you’ll also like the challenges and responses posted at http://chandoo.org/forum/forums/excel-challenges/
The challenges all call for a single formula, and some of the standouts include:
* working out if a number above 1048576^2 is a prime number (meaning you can’t simply generate a consecutive array of integers based on the number of rows in a worksheet)
* producing distinct/duplicate/unique arrays from a list containing text AND numbers
* Counting the number of times a numeric array occurs in another
* Doing Two-way interpolation
* Turn non-contiguous, different sized 1D ranges into one 1D range
Hours of fun!
Also, Mike Girvin’s YouTube channel has some great stuff along the same lines.
Comment by Jeff Weir — September 4, 2013 @ 7:34 am
Jeff,
Thanks for the heads up with Chandoo’s challenges. I have added it for a coming articles.
Kind regards,
Dennis
Comment by Dennis M Wallentin — September 4, 2013 @ 1:16 pm