Hi,
I have created a nice little Filter function based on a table which I am proud of as I'm just getting into the Depths of Excel and loving it. As part of my Filter function I put it inside another to pull specific columns from the table. As such I have a string like so, {1,1,1,0,0,0,1,1,0,1,1,0,1,1,0,0,0,0,0}.
Is it possible to recreate this string in a formula such that if I add columns to the table the same headers I require will be 1's where as the new column/columns I don't need are 0's?
e.g. {1,1,1,0,0,0,1,1,0,1,1,0,1,1,0,0,0,0,0} Becomes {1,1,1,0,0,0,1,1,0,"0,0",1,1,0,1,1,0,0,0,0,0} after adding two new columns in the middle of the table. (I put the added 0's in "" so you can identify where I added them, I obviously don't require them in the string.
I'm either on Excel 365/Excel 21 version not 100% sure on which. (Although I believe it's 365.
I have created a nice little Filter function based on a table which I am proud of as I'm just getting into the Depths of Excel and loving it. As part of my Filter function I put it inside another to pull specific columns from the table. As such I have a string like so, {1,1,1,0,0,0,1,1,0,1,1,0,1,1,0,0,0,0,0}.
Is it possible to recreate this string in a formula such that if I add columns to the table the same headers I require will be 1's where as the new column/columns I don't need are 0's?
e.g. {1,1,1,0,0,0,1,1,0,1,1,0,1,1,0,0,0,0,0} Becomes {1,1,1,0,0,0,1,1,0,"0,0",1,1,0,1,1,0,0,0,0,0} after adding two new columns in the middle of the table. (I put the added 0's in "" so you can identify where I added them, I obviously don't require them in the string.
I'm either on Excel 365/Excel 21 version not 100% sure on which. (Although I believe it's 365.