Categories
Custom functions used in Google Sheets for ease of use and improved functionality.
View On GitHub
Status
Theme Update - jekyll-theme-leap-day
Welcome to First Post!
gsSQL
Using gsSQL Library
How to Find Duplicates in Google Sheets [using gsSQL custom function]
Google Sheets Query function: The Most Powerful Function in Google Sheets
Using a calculation to evaluate JOIN condition.
Custom Function Triggered on Data Changes
GROUP BY in gsSQL
Bind Variables in gsSQL
Select where EXISTS using correlated Sub Query
Correlated Sub Query
Select2Query
Generate Google Sheets QUERY from Standard SQL
CanadianTaxes
Finding a good estimation of future RRSP withdrawals