Column formula using string varialble for column names
Jun 12, 2009 8:56 PM(1939 views)
I'm trying to create a bunch of new columns with formulas based on existing columns. New column statement is inside For loop and I want to use strings from a list as part column names. My columns are from the table constructed by Summary function, thus they have "," in the names
It all seems a bit clunky to me, but it was the only variant that I could get to work. I should also note that my As Column() statement was parsing another column from inside functions like Substitute(), Item(), and Word().