Google Sheets: Tips & Tricks

Will be amended as time goes by! 😄

Data Validation

1. Custom formula for uniqueness of values in a column with only text values:
   =EQ(COUNTUNIQUE(A:A), COUNTA(A:A))

Google AppsScript

1. Just learnt that if you define your JavaScript classes in one .GS script file, it has to be above the the other .GS script file if you want to inherit from any those classes in the other .GS script file. Awkward!

LAMBDA: The ultimate Microsoft Excel worksheet function

Recommendable! Very interesting stuff! Now how will Google Sheets respond to this challenge?

It is a bit disingenuous by these authors not to mention the famous and great predecessor of Microsoft Excel, i.e. Lotus 1-2-3 or VisiCalc (quite possibly the first major spreadsheet software for personal computers).

"... In December 2020, we announced LAMBDA, which allows users to define new functions written in Excel’s own formula language ... These newly defined functions can call other LAMBDA-defined functions, to arbitrary depth, even recursively. With LAMBDA, Excel has become Turing-complete. You can now, in principle, write any computation in the Excel formula language. ..."

LAMBDA: The ultimate Excel worksheet function - Microsoft Research