Pages

▼
Monday, February 20, 2017

Google Script to auto delete old files from a Google Drive Folder

›
If you are creating auto backup of any file in Google Drive using script ( either daily or on any edits ), so the number of back up file kee...
4 comments:
Thursday, November 12, 2015

Google Spreadsheet Count of colored cells in a range in Custom Function

›
Count of colored cells in a range in Custom Function I have the following formula in cell E9: = countColoredCells ( A1:C6 , E1 ) an...
124 comments:
Wednesday, November 11, 2015

Google Spreadsheet Sum of a colored cells in a range in Custom Function

›
Sum of a colored cells in a range in Custom Function I have the following formula in cell E9: = sumColoredCells ( A1:C6 , E1 ) and ...
101 comments:
Saturday, November 7, 2015

Google Spreadsheet Getting the last 5 values before the previous last 5

›
Question: Hi, I am trying to get the average values in a row present at the last 5 rows before the last 5 rows, in other words in a sheet ...
Wednesday, November 4, 2015

Google Spreadsheet Script for manipulating JSON

›
The following URL " http://shanghai.anjuke.com/ajax/pricetrend/comm?cid=10052 ", has the JSON data: Now to fetch this data in...
2 comments:
Friday, October 23, 2015

Google Spreadsheet return a subset given complex criteria

›
Question: Here is my sample sheet: Given the example data in this sheet, I want to return a subset automatically that meets the...
Friday, October 9, 2015

Google Spreadsheet generating a list of the most frequently used words in an entire sheet

›
Question: Hey guys, I have a spreadsheet made up of columns that list the top 100 search terms on a website for each month of the year. ...