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.
Thursday, July 10, 2014
yogi_Pull From Sheet named 'RAW data' Values For Field Selected Via DropDown In Cell A1 For Month And Year of Date in Cell B1
Google Spreadsheet Post #1693 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Jul-10-2014 post by Nieboy1: (https://productforums.google.com/forum/#!mydiscussions/docs/GjjLdQBbqVU) sort by multiple column referances
HI I am looking for a little help with a formula I have made to query based on cell references.
In sheet 'monthly rankings' at cell A3 I would like to query RAW data for A) month and B) a statistic
I would like these to be variable, meaning I would like to be able to select from a list of available options.
I have cut and pasted my expected results in monthly rankings.
Monthly rankings as it is now is an exact "snapshot" of what I am looking for, including the "variable" cells in A1 and B1, however there is no formula I just cut and pasted the correct rows and then sorted them manually.