All Possible CombinationsProblem: Make a list of all combinations of k elements chosen from a pool of n values in Google Sheets.Dec 12, 20224Dec 12, 20224
Replace text in Google Spreadsheets with Apps Script — IIReplace text on a different Google Sheet.Jun 18, 202110Jun 18, 202110
FIFO on a Google SheetsCalculate the purchase value of current inventory (or shares held) using FIFO, first-in-first-out, inventory method on a spreadsheet.May 2, 2021May 2, 2021
Write Data to Google Sheets using Apps ScriptHow to use batch operations with defined and undefined arraysMar 24, 2021Mar 24, 2021
Replace text in Google Spreadsheets with Apps ScriptGoogle Sheets has a powerful find and replace function. But you may want to use Google Apps Script to do the same job.Mar 18, 2021122Mar 18, 2021122
Save PDF from URL directly to Google Drive using Google Apps ScriptThere is a PDF file on the Internet. Say this one.Feb 25, 20215Feb 25, 20215
Open a URL using Google Apps ScriptThis question was asked and answered on StackOverflow.Feb 22, 20212Feb 22, 20212
Google Sheets Data Validation using Google Apps ScriptData Validation: to control what a user can enter into a cellAug 29, 201952Aug 29, 201952
Your passwords suck at security…Your passwords suck at security because no one taught you how to choose a password. Here’s what you need to teach your kids about…Aug 15, 20172Aug 15, 20172