I have a list of cells with data inside, separated by a ,
I would like to extract all the value that are common to each cells.
It works, I stole it from internet, I don’t understand it but it just works

I’m not really good in excel so don’t ask to complexes questions and don’t use Macro.

=LET(x; TRANSPOSE(TEXTSPLIT(TEXTJOIN(“, “;TRUE;C2:C3); “, “));y;UNIQUE(x);z;UNIQUE(x;;1); TEXTJOIN(“, “;TRUE;IF(ISERROR(MATCH(y;z;0));y; “”)))

My issue is that it only works for 2 cells.
If I test 3 or more, it will keep all value that appear several time, but I need to keep value that appeared in every single cell, not just 3 out of 4.