Tag
formulas
Translate Excel Formulas Into Another Language In PHP Using PHPSpreadSheet
PhpSpreadsheet ships sixteen languages, so you can translate Excel formulas from English into French, German or Dutch with two calls. The argument separator changes with them, and a…
August 16, 2026 · PhpSpreadsheet
Write Reusable Formulas With The LAMBDA Function And LET
Name the repeated parts of a formula, then define a function, name it and call it, all inside one cell. This article works up from a formula that…
August 15, 2026 · Google Sheets Formulas
Replace Fill Down With The ARRAYFORMULA Function In Google Sheets
One formula that calculates a whole column, including the rows that do not exist yet. This article replaces a filled-down column with a single array formula, covers the…
August 15, 2026 · Google Sheets Formulas
Pull Live Data Into Google Sheets With The IMPORT Functions
Bring another spreadsheet, a web list, an XPath match, an RSS feed or a CSV into a cell and keep it current, without a line of code. Every…
August 14, 2026 · Google Sheets Formulas
Replace VLOOKUP With The XLOOKUP Function In Google Sheets
Look values up without counting columns, search leftwards, return a whole record, and handle the miss in an argument rather than a wrapper. This article shows what XLOOKUP…
August 14, 2026 · Google Sheets Formulas
Combine The FILTER Function With SORT And UNIQUE In Google Sheets
Keep the rows that match, drop the repeats and order what is left, all from a single cell. This article builds the three functions separately then composes them,…
August 14, 2026 · Google Sheets Formulas
Write SQL In A Cell With The Google Sheets QUERY Function
Filter, group, sort and total a Google Sheet from inside a single cell, using the same select and where clauses you would write against a database. This article…
August 13, 2026 · Google Sheets Formulas
Clear The Formula Calculation Cache In PHP Using PHPSpreadSheet
PhpSpreadsheet memoises every formula result it works out, so changing a cell and reading the formula again hands back the previous answer with no error at all. This…
August 13, 2026 · PhpSpreadsheet
Use VLOOKUP In Excel Files In PHP Using PHPSpreadSheet
VLOOKUP searches the first column of a table and returns a value from the same row. Write one across a lookup table with PhpSpreadsheet, get the absolute-versus-relative references…
August 6, 2026 · PhpSpreadsheet