cellsummer
/ lambdas.txt
Created
October 31, 2025 17:14
— forked from jimpea/lambdas.txt
Some usefull Excel Lambda functions
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Append two ranges horizontally. | |
| Inputs: | |
| - range1: the first range | |
| - range2: the second range | |
| - default: the value entered into missing rows. | |
| Return: The merged ranges, with empty rows filled with the default value. Missing | |
| value within either of the two ranges filled with zeros (0). The number of rows |