Saturday, February 18, 2017

yogi_In Rows C2:I And Down Pull Row By Row Values From Last Seven Columns Of The Corresponding Rows

Google Spreadsheet   Post  #2117
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-18-2017
question by GeoTechGuy:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/e7-heDOyIr4;context-place=mydiscussions
Filter view dynamically
Hi, 

I have to following formula that works great at the moment but, as I add columns to the sheet I don't want to have to edit the formula each time. Is there a way (maybe via script) to filter view every 6th column? Below is the script that works but I need a way to have complete the same function without having to edit it all the time as columns are added. For example, when I add columns GS-GY, I need a script that will recognize GY as the 6th column and add it to the filter. 


=filter(({K2:K;R2:R;Y2:Y;AF2:AF;AM2:AM;AT2:AT;BA2:BA;BH2:BH;BO2:BO;BV2:BV;CC2:CC;CJ2:CJ;CQ2:CQ;CX2:CX;DE2:DE;DL2:DL;DS2:DS;DZ2:DZ;EG2:EG;EN2:EN;EU2:EU;FB2:FB;FI2:FI;FP2:FP;FW2:FW;GD2:GD;GK2:GK;GR2:GR}),NOT(ISBLANK(({K2:K;R2:R;Y2:Y;AF2:AF;AM2:AM;AT2:AT;BA2:BA;BH2:BH;BO2:BO;BV2:BV;CC2:CC;CJ2:CJ;CQ2:CQ;CX2:CX;DE2:DE;DL2:DL;DS2:DS;DZ2:DZ;EG2:EG;EN2:EN;EU2:EU;FB2:FB;FI2:FI;FP2:FP;FW2:FW;GD2:GD;GK2:GK;GR2:GR}))))



Thanks all.