Pages

▼
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. ...
Wednesday, October 7, 2015

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' tha...
2 comments: