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, April 14, 2018
yogi_Create A Template For Reporting Data By Specified Month Beginning With Monday In Which First Of The Month Falls
How do you write a function as a range? In Google Sheets, how do you create a variable range function?
I want to display a data set located somewhere else. So thought to use the INDEX function.
The problem is that I'm creating a template and thus the data set isn't always in the same place. So I thought to write the range for INDEX as an ADDRESS function and a MATCH function. However, no matter what I try I can't make it work.
An example [=index(address(match(J26,B:B),2,4):address(match(J26,B:B)+6,6,4))]
The problem seems to be that a function cannot serve as a variable. The INDEX function returns an error stating that the argument must be a range.
Is there a way to make this work or maybe a better way to get the same result?