In addition to being pretty good with formulas, youвЂ™ll need to understand the concept of iteration. Lots of people have created more powerful solvers, many as spreadsheets, some using just formulas, but I wanted to try to explain how you can go about creating a solver and hopefully share some formula tricks that people find useful.Д¬reating a spreadsheet for solving a Sudoku isnвЂ™t entry-level spreadsheeting.

IвЂ™ve always wanted to blog about the process of creating this spreadsheet and about how iterative formulas work to show the power of ExcelвЂ™s formula language, because it illustrates the usefulness of circular references and iterative calculation, and because I just think itвЂ™s an incredible amount of fun so here goes. I think it might even have turned up a reasonably useful way at looking at abstraction within formulas given the Excel formula language. It turned out to not be that tough to build, but I think I learned a fair amount trying different approaches to the problems of making an iterative model like this one perform well and at the same time be reasonably maintainable and understandable. In fact, Dan made every single cell its own different formula, and he ended up having to use VBA to create the formulas because maintaining and debugging it without VBA to write all those different formulas in an automated way was impossible.ДЄs soon as I saw DanвЂ™s spreadsheet, I wanted to make my own version of a Sudoku solver that not only used only formulas, but also one where the formulas were relatively understandable and there were a small number of distinct formulas. ItвЂ™s quite cool and has been a popular download, but one thing about the spreadsheet that I wanted to see if I couldnвЂ™t improve upon was just how complicated it is. DanвЂ™s spreadsheet was great in that, unlike many of the Sudoku solving spreadsheets out there, it didnвЂ™t use any VBA or other scripting to do the work of solving the puzzles, and relied instead on the iterative calculation feature of Excel. The spreadsheet can be found in the attachments at the bottom of this post.ДЇor those of you who donвЂ™t already know, Sudoku is a type of logic puzzle (that I was completely addicted to about three years ago) that requires you to place the numbers 1-9 into a grid obeying certain rules ( lots more information on Sudoku is available on the web).ДЄ while back, a fellow PM on the Excel team, Dan Cory, wrote a spreadsheet for solving Sudoku puzzles using Excel formulas and made it available on Office Online ( here). Set myRange = Worksheets('Sheet1').Range('A1:C10')TodayвЂ™s author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles. My problem is that I constantly get crashes, and loose data where the excel states NAME PROBLEM, Ive tried to get a beginers guide on web no job, just ordered some books to help.ДЇor now can anone tell me is there a way to declare a formula and relate it to a cell within excel, thereby avoiding using 'rem or ' ' at the beginng of a line. function g(x), 'then type in' g = 'some equation of

I have been instructed to enable developer on excel, click on VBA, click insert, 'module', which pops up a window, enter a function into the window. Id like to create 3 versions of x for each f(x), and have the 3 calculations on the same page. The main use I need for the formula, is to reuse the formula on a variety of iterations of f(x). Please can someone tell me how could I do this if what I require is possible. Set myRange = Worksheets('Sheet1').Range('A1:C10')ДЄnd wondered is this the key to my quest. My problem is that I constantly get crashes, and loose data where the excel states NAME PROBLEM, Ive tried to get a beginers guide on web no job, just orderedДЇor now can anone tell me is there a way to declare a formula and relate it to a cell within excel, thereby avoiding using 'rem or ' ' at the beginng of function g(x), 'then type in' g = 'some equation of x' Hi there hoping someone can give me some pointers, as sadly my teacher gave us very little to go on, never used developer VBA within excel before last week.

Using microsoft visual basic for excel