I wrote a simple Sudoku solver in Excel about a year ago, and was pretty pleased with myself but gave up on the more advanced solving techniques which were beyond my meagre coding skills and (more to the point) my patience. But that was in VBA... it never occurred to me that it might be possible to achieve the same just using Excel formulas and without writing a line of code.
So I'm loving Charlie Ellis' post walking us through doing just that, which made me look at familiar functions in completely new ways.
Up until today I thought I was a pretty advanced Excel user, but I now I've realised that all this time I've been missing out on defined names for formulas. Which probably makes me a complete Excel dunce in the eyes of anyone who really knows what they're doing, but hey, I'm happy that I know now.
Now I just have to get my head around array formulas...
No comments:
Post a Comment