If you’re looking for articles relating to advanced, formula-based Excel solutions then you’ve come to the right place.
Please visit my blog to see a whole host of innovative techniques developed using worksheet formulas alone. These techniques – accompanied by detailed and instructive explanations of their workings – are not only of theoretical interest to the reader wishing to explore the possibilities of what can be achieved in this field, but also offer practical solutions to a plethora of everyday issues which the average Excel user may encounter.
There are also regular formula challenges to test your own abilities, the results, solution and analysis to which are then given the following week.
I deliberately set this site up with the intention of avoiding VBA-based solutions. Not that I have any objections to that area, but, the more I delve into the workings of Excel functions, the stronger my belief that there is a lot more which can be achieved using worksheet formulas alone. I sincerely hope that readers of this site will come away with that impression too.