With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, February 18, 2017
yogi_In Rows C2:I And Down Pull Row By Row Values From Last Seven Columns Of The Corresponding Rows
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.