N2:N21=IF(B2,"",IFERROR((COUNTIF(C2:M2,"V")&LOOKUP(1,0/(C2:M2<>""),C$1:M$1)),0))
P2:P21{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(B$2:B$21=0,MMULT(N(C$2:M$21<>""),ROW(1:11)^0)*10^6+RIGHT(SMALL(ROW(2:21)/1%%+(C$2:M$21<>"")*C$1:M$1,ROW($1:$20)*11),4)*10^3+ROW($2:$21)),ROW(A1)),3)),"")
Q2:Q21{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(N$2:N$21<>"",N$2:N$21/1%+ROW($2:$21)),ROW(A1)),2)),"")
留言
張貼留言