ExcelRobot

/*
Name: Direct Precedents (DIRECTPRECEDENTS)
Description: Lists all direct precedents for specified cell.
Author: Excel Robot (@ExcelRobot)
Category: Formula
*/
DIRECTPRECEDENTS = LAMBDA(cell,LET(
   tokens, TOKENIZEFORMULA(OFFSET(cell,0,0,1,1)),
   isterm, INDEX(tokens,,1)="Term",
   activesheetname, MID(CELL("filename",INDIRECT("$A$1")),FIND("]",CELL("filename",INDIRECT("$A$1")))+1,999),

nsolnit

/**Cumulative sum over array*/
CSUM = LAMBDA(arr,
    SCAN(0,arr,LAMBDA(a,c,a+c)));

/**Ignores Null ref (empty, space or 0), returns "" or VAl if provided*/
IFN = LAMBDA(REF,FUN,[VAL],
IF(OR(REF="",REF=" ",REF=0),IF(ISOMITTED(VAL),"",VAL),FUN)
);

/**1D linear interpolation, set SORTED=0 for unsorted data - presorting data recommended*/

over40dev

/* See YouTube - Excel RECURSIVE Lambda (https://youtu.be/L7s6Dni1dG8) */
/*
    FUNCTION NAME: MegaReplace
    DESCRIPTION: Recursive LAMBDA for clean data given errors to look for and corrections. Recursively calls MegaReplace using Offset for Before|After table cells until end of table (i.e. blank cell)
    ARGS:
        text_to_correct: Contains the first table cell of data to be cleaned,
        before_text: First cell of Before|After table of corrections [BEFORE] column,
        after_text: First cell of Before|After table of corrections [AFTER] column
    EXAMPLE:
        =MegaReplace([@Skills],$F$3,$G$3) // Skills is column in main table; F | G are first cells in Before|After table

jkpieterse

cpreg1 = LAMBDA(temp, press,
    LET(
        tau, 1386 / temp,
        pi, 0.1 * press / 16.53,
        -0.001 * rgas_water * tau ^ 2 * gammatautaureg1(tau, pi)
    )
);

cpreg2 = LAMBDA(temp, press,
    LET(

jimpea

/*
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

SergeiStPete

/*
calc(n) - integrates aggregation function with
            BYROW() or BYCOL(), where
            n - number of aggregation function
That is simple sample without error handling
and help output.

Used as:
=BYROW( range, calc(n) )