2007版 C2:C4{=IFERROR(MODE(IF((COUNTIF(C$1:C1,TRIM(MID(SUBSTITUTE(A$1:A$3,",",REPT(" ",99)),COLUMN(A:I)*99-98,99)))=0)*(TRIM(MID(SUBSTITUTE(A$1:A$3,",",REPT(" ",99)),COLUMN(A:I)*99-98,99))<>""),TRIM(MID(SUBSTITUTE(A$1:A$3,",",REPT(" ",99)),COLUMN(A:I)*99-98,99))*1)),"")
數字限制 最多26 改COLUMN(A:Z)的 Z 可增大 D2:D4{=IFERROR(MODE(IF(ISNUMBER(FIND(","&COLUMN(A:Z)&",",","&A$1:A$3&","))*(COUNTIF(D$1:D1,COLUMN(A:Z))=0),COLUMN(A:Z))),"")
留言
張貼留言