You'll be asked to select two ranges and a cell where you want the resultset to be placed (it's usually better to put the resultset on a seperate worksheet) You'll see your cartesianproduct macro in a list. Start your macro by visiting the Developr tab and then click Macros.
All that is needed now is to have two ranges of data. You will see that your macro now has a name "cartesianproduct":Ĭlose the Visual Basic Editor and return to Excel. Set startrange = Application.InputBox(Prompt:="Please select where you want to put it", Type:=8)ĪctiveCell.Offset(z, 0).Value = array1(i, 1)ĪctiveCell.Offset(z, 1).Value = array2(x, 1) Range2 = Application.InputBox(Prompt:="Please Select Second Range", Type:=8) Range1 = Application.InputBox(Prompt:="Please Select First Range", Type:=8)
Creating excel for adwords editor code#
You need to create a Module in your wookbork, so right-click on the Modules folder and choose Insert > Module:Ĭopy the following code into the right-hand side of the Visual Basic Editor (big thanks to Andrew Edge for his masterful VB skills): Visual Basic to the rescue! Here is how you make a cartesian product macro in Excel 2007:įirstly open your Developer tab and click Visual Basic to open the Visual Basic Editor you should see something like this: Simple right? The problem is there isn't a cartesian product macro that works out of the box and even common excel plugins like ASAP Utilities don't have one either. You need a marco that runs through your two ranges and gives you a new range of all the possible combinations. So how do I create a cartesian product in Excel? Although normally used in mathematics, it is a process that can also be applied to non-numerical data sets like table fields (in SQL) or ranges (in Excel): If you want to create a result set of all possible combinations of two tables then you want a cartesian product! In essence a cartesian product is the result set of all possible ordered pairs of data. You probably already knows what a cartesian product is, even if you don't know that that is what it is called. If youre a spreadsheet wizard, this AdWords Editor benefit allows you to make changes via Excel and then upload them as CSVs into AdWords Editor. When I first asked my "goto excel guy" how I created one, I didn't know that what I was asking for had a specific, flashy name. The term cartesian product sounds flash doesn't it? Like some sort of Star Trek thingy wossit.
0 kommentar(er)
