How to use GoogleTranslate() with Arrayformula()
Using GoogleTranslate in array formulas in Google Sheets.
Convert a Date to FY-Quarter format for the July-June Financial Year
How to convert dates to FY-Quarter format for the July-June financial year.
How to Sum a Column in Google Sheets
How to sum a column in Google Sheets — multiple ways, including a quick shortcut.
How to create Dynamic Arrays in Google Sheets with Concatenate, Split and Transpose
How to create dynamical arrays and tables in Google Sheets
How to Make Tables in Google Sheets — Three Easy Ways
A complete guide to making a table in Google Sheets — three easy ways.
XLOOKUP in Google Sheets — Two Equivalents and Alternatives
How to use XLOOKUP in Google Sheets — Equivalents, alternatives, and even improvements…