DistinctList

DistinctList.txt

/** DistinctList */
/*
    FUNCTION NAME: DistinctList
    DESCRIPTION: Given a n-row by 1-column range of concatenated text,
        returns a n-row by 1-column array of the unique values. Not
        sorted (use DistinctListSort to get sorted list)
    ARGS:
        rng: Range holding original values
        delim: Delimiter used to split the concatenated strings
        col: Column index you want returned (1st column = 1)

    EXAMPLE: 
        =DistinctList(A1:A1000,"|",4)
*/
DistinctList = LAMBDA(
    rng,
    delim,
    col,
    UNIQUE(
        BYROW(
            rng,
            LAMBDA(
                r,
                INDEX(
                    TEXTSPLIT(
                        r,
                        delim
                    ),
                    col
                )
            )
        )
    )
)