E2=COUNTIF(A$2:A2,"<>")&IF(A2="","."&COUNTIF(OFFSET(B2,,,LOOKUP(1,0/(A$1:A1<>""),ROW($1:1))-ROW()),"<>"),"")&IF(C2="","","."&COUNTIF(OFFSET(C2,,,LOOKUP(1,0/(B$1:B1<>""),ROW($1:1))-ROW()),"<>"))
另解=COUNTA(A$2:A2)&TEXT(COUNTA(INDEX(B$2:B2,MATCH("嫻",A$2:A2)):B2),"\.0;;;")&TEXT(COUNTA(INDEX(C2:C$2,IFERROR(MATCH("嫻",B$2:B2),)):C2),"\.0;;;")
F2=LOOKUP("嫻",A2:C2)
留言
張貼留言