Skip to content

Instantly share code, notes, and snippets.

@ndthanh
ndthanh / vEquivalents.gs
Created Sep 28, 2020 — forked from brucemcpherson/vEquivalents.gs
Google Apps Script equivalents for common VBA function
View vEquivalents.gs
/** @description
* javaScript/Google Apps script functions that are equivalent to common VBA functions
* in general these provide the same functionality and have the same calling stack
* See http://ramblings.mcpher.com/Home/excelquirks/codeuse for more details
* @author <a href="mailto:bruce@mcpher.com">Bruce McPherson</a><a href="http://ramblings.mcpher.com"> ramblings.mcpher.com</a>
*/
/**
* Removes leading and trailing whitespace
* @param {string|number} v the item to be trimmed
@ndthanh
ndthanh / fuzzy_name_lookup.bas
Created Nov 20, 2017 — forked from draffensperger/fuzzy_name_lookup.bas
Excel VBA module for fuzzy lookup (via Levenshtein distance) for a person id by first name and last name in a person range that has first, last, full and id fields.
View fuzzy_name_lookup.bas
Option Explicit
Private Type PersonQuery
firstName As String
lastName As String
fullName As String
firstNames As Range
lastNames As Range
fullNames As Range
namesSwapped As Boolean