patogeno

/*
    It searches for a value inside an array and ouputs a list with all the rows that include it.
    
    Inputs:
        - lookup_value [text]
        - lookup_array [array where the lookup value is searched]
        - value_array [array of values to return]
*/
MULTILOOKUPINCLUDE = LAMBDA(
    lookup_value,

duboisbarron

/* Reverses an n-dimensional array */
REVERSE_ARR =LAMBDA(my_array,
    LET(
        row_length, ROWS(my_array),
        col_length, COLUMNS(my_array),

        IF(col_length = 1,
        /* its a vertical list, reverse it*/
        MAKEARRAY(row_length, 1, LAMBDA(row, col, INDEX(my_array, row_length - row + 1))),
        /* horizontal array */

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(

jkpieterse

QuadraticEquation = LAMBDA(a, b, c,
    (-b + {-1, 1} * SQRT(b ^ 2 - 4 * a * c)) / 2 / a
);

jkpieterse

SheetName =LAMBDA(cl,LET(f,CELL("filename",cl),MID(f,FIND("]",f)+1,LEN(f))))

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

KhaledAHabib

NoNumbers = lambda(TextCell,TEXTJOIN("",FALSE,IF(ISNUMBER(MID(TextCell,SEQUENCE(1,LEN(TextCell)),1)*1),"",MID(TextCell,SEQUENCE(1,LEN(TextCell)),1))));
Reverse = LAMBDA(TextCell,TEXTJOIN("",FALSE,MID(TextCell,SEQUENCE(1,LEN(TextCell),LEN(TextCell),-1),1)));
PROPERSPACE = LAMBDA(Text, LET(TextUpper,MID(UPPER(Text),SEQUENCE(1,LEN(Text)),1),TextLower,MID(Text,SEQUENCE(1,LEN(Text)),1),TRIM(TEXTJOIN("",TRUE,IF(CODE(TextUpper)=CODE(TextLower),SUBSTITUTE(TextLower,TextLower," "&TextLower),TextLower)))));
Compare = LAMBDA(Range1,Range2,TEXTJOIN("|",TRUE,IF(Range1<>Range2,ADDRESS(ROW(Range2),COLUMN(Range2)),"")));
WordSearch = LAMBDA(STARTCELL,TARGETWORD,IF(OR(STARTCELL&""=LEFT(TARGETWORD),STARTCELL="?"),IF(LEN(TARGETWORD)=1,TRUE,OR(WordSearch(OFFSET(STARTCELL,-1,0),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,1,0),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,0,1),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,0,-1),MID(TARGETWORD,2,LEN(TARGETWORD))),)),FALSE));
Hail

ExcelExciting

HIJRIAGE =
/*Hijri Age Calculator allows you to calculate the age of person as per arabic calander.
https://excelexciting.com/how-to-calculate-hijri-age-in-excel/
EXAMPLE:
=HIJRIAGE("3/3/1991") 
RESULT>> 31 years 10 months 25 days 
If you like to cacluate the Gregorian Age then you need enter next argument as "g"
EXAMPLE:
=HIJRIAGE("3/3/1991","g") 
RESULT>> 30 years 11 months 11 days

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) )

Softwaretrain

/*
    FUNCTION NAME: ABH
    VERSION:1.0
    AUTHOR: Mahmoud Bani Asadi
    WEB: www.arshad-hesabdar.ir
    INSTAGRAM: @SoftwareTrain
    DESCRIPTION:         
        This function converts a numeric value (integer or decimal) into its full Persian text representation.
        It handles negative numbers by prefixing "منفی"، separates the integer part into named segments 
        (تریلیارد، میلیارد، میلیون، هزار)، and converts the fractional part into fractional units