19 followers -

19 followers
Post has attachment
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 keeps on increasing. Now, if you want to delete the excessive files, for example if you want to delete all the files exc...﻿
Post has attachment
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 ) and the following formula in cell F9: = countColoredCells ( A1:C6 , F1 ) Put the following script code in the script editor of y...﻿
Post has attachment
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 the following formula in cell F9: = sumColoredCells ( A1:C6 , F1 ) Insert the following is the script in the script editor of ...﻿
Post has attachment
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 with 15 rows in a column I would like to know how to attain the average value of rows 5 to 10. Solution: Following is t...﻿
Post has attachment
The following URL " http://shanghai.anjuke.com/ajax/pricetrend/comm?cid=10052 ", has the JSON data: Now to fetch this data in Google Spreadsheet, use the following script: ///////////////////////////////////////////////// function extract(url){   var respon...﻿
Post has attachment
Question: Here is my sample sheet: Given the example data in this sheet, I want to return a subset automatically that meets the following criteria: * 4 total rows * 1 row where color=green * 1 row where color=red * 2 rows where color=blue * The COMBINED val...﻿
Post has attachment
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. Is there a formula I can use to search all of the columns and generate a list of the overall top 20 terms? Any help would...﻿
Post has attachment
Google Sheet Select items by column that contains few parameters separated by comma
Question: Hi everyone, I am trying to create some sort of inventory database using google sheets. I have one sheet 'Inventory' that lists all the items in my database. In another sheet 'Search' I want to have an ability to display items that qualify size di...﻿
Post has attachment