Pages

▼
Saturday, August 5, 2017

Google Sheet Script to Navigate various HTML Pages

›
Here is the Google Sheet Script to Navigate various HTML Pages by passing the needed data via URL parameter. Screencast: F...
Monday, July 3, 2017

Google Sheet Script for border style

›
Question: I have columns and rows: D69:J79 filled with data, data in rows is changing on daily basis, one day it’s D69:J79, another it’s ...
Saturday, July 1, 2017

Google Sheet Script to extract URL from a Cell containing function HYPERLINK

›
In Google Sheet, if you have a cell or a range containing functions HYPERLINK and if you want to extract URL(s) from it then you can do it w...
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 ...