C2=MODE(MMULT(1-ISERR(FIND(" "&TRIM(MID(SUBSTITUTE(B2," ",REPT(" ",19)),COLUMN(A:I)*19-18,19))&" "," "&B$2:B$6&" ")),ROW(1:9)^0))
E2{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE(OFFSET(B$1,MATCH(MAX(C:C),C:C,)-1,)," ",REPT(" ",19)),COLUMN(A:I)*19-18,19)),SMALL(IF(ISERR(FIND(" "&TRIM(MID(SUBSTITUTE(OFFSET(B$1,MATCH(MAX(C:C),C:C,)-1,)," ",REPT(" ",19)),COLUMN(A:I)*19-18,19))&" "," "&INDEX(B:B,SMALL(IF(C$2:C$6=MAX(C$2:C$6),ROW($2:$6)),2))&" ")),"",COLUMN(A:I)),ROW(A1))),"")
留言
張貼留言