Forum Discussion

Copper Contributor

May 02, 2023

Are two cells the same if the order is different in excel

If the order does not matter, what formula should I use to prove these are all same

Iron Contributor

May 02, 2023

=COLUMNS(
    UNIQUE(
        BYCOL(A1:D1,LAMBDA(ζ,TEXTJOIN("|",,SORT(TEXTSPLIT(ζ,,";"))))
        ),
    1)
)=1

Regards