嘟嘟。。吭哧,吭哧 07版超级长火车
I1
=TRIM(MID(SUBSTITUTE(LOOKUP(,0/FREQUENCY(ROW(),MMULT(N(ROW($1:$5)>=TRANSPOSE(ROW($1:$5))),TRANSPOSE(LEN($A$1:$E$1)-LEN(SUBSTITUTE($A$1:$E$1,"、",""))+1))),$A$1:$E$1),"、",REPT(" ",99)),SUM(N(IFERROR(LOOKUP(ROW(A1),MMULT(N(ROW($1:$5)>=TRANSPOSE(ROW($1:$5))),TRANSPOSE(LEN($A$1:$E$1)-LEN(SUBSTITUTE($A$1:$E$1,"、",""))+1))+9^-9),)=IFERROR(LOOKUP(ROW(A$1:A1),MMULT(N(ROW($1:$5)>=TRANSPOSE(ROW($1:$5))),TRANSPOSE(LEN($A$1:$E$1)-LEN(SUBSTITUTE($A$1:$E$1,"、",""))+1))+9^-9),)))*99-98,99))
数组
|