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, January 5, 2013
yogi_Compute Row By Row Average Considering Every Nth Column of An Open Ended Range
user collin.m.barrett said:(http://productforums.google.com/forum/?zx=6xwd73m1l93e#!category-topic/docs/spreadsheets/0StscdBKHo0) SELECT every nth cell in a row
I am using equations similar to the following to select the values in every 5th column of a given row. Is there a way to do this dynamically rather than typing in each individual cell reference? Thanks.