Skip to content

Instantly share code, notes, and snippets.

{"version":1,"resource":"file:///Users/angel/Desktop/code/vault-repos/vault/ui/app/models/oidc/provider.js","entries":[{"id":"4bcC.js","timestamp":1675370200093}]}
@Monkeychip
Monkeychip / gist:8015dcd872aab1ffafd9a7c867f5e7cc
Created December 16, 2016 21:52
Compare arrays, including from other spreadsheets, and count similarities
function bamboo(){
// var ss = SpreadsheetApp.openByUrl('');
// var ss = importrange("");
var ss17 = SpreadsheetApp.getActive();
var sheet = ss17.getSheets()[1];
var values = sheet.getRange("A2:A").getValues();
var lastRow = values.filter(String).length;
//Current year
var sheet17 = ss17.getSheets()[0];
blah