All Possible CombinationsProblem: Make a list of all combinations of k elements chosen from a pool of n values in Google Sheets.Dec 12, 2022Dec 12, 2022
Replace text in Google Spreadsheets with Apps Script — IIReplace text on a different Google Sheet.Jun 18, 2021Jun 18, 2021
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, 20212Mar 18, 20212
Save PDF from URL directly to Google Drive using Google Apps ScriptThere is a PDF file on the Internet. Say this one.Feb 25, 2021Feb 25, 2021
Open a URL using Google Apps ScriptThis question was asked and answered on StackOverflow.Feb 22, 2021Feb 22, 2021
Google Sheets Data Validation using Google Apps ScriptData Validation: to control what a user can enter into a cellAug 29, 2019Aug 29, 2019
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, 2017Aug 15, 2017