I2{=INDEX(A:A,SMALL(IF(MMULT(N(D$2:G$12="V"),{1;1;1;1})>={1,2,3,4},ROW($2:$12),99),ROW(A1)))&""
J2{=IFERROR(INDEX($1:$1,SMALL(IF(VLOOKUP(I2,A:G,{4,5,6,7},)="V",{4,5,6,7}),COUNTIF(I$2:I2,I2))),"")
L2{=INDEX($1:$1,SMALL(IF(MMULT(COLUMN(A:K)^0,N(D$2:G$12="V"))>=ROW($1:$11),{4,5,6,7},99),ROW(A1)))&""
M2{=IFERROR(INDEX(A:A,SMALL(IF(HLOOKUP(L2,A:G,ROW($2:$12),)="V",ROW($2:$12)),COUNTIF(L$2:L2,L2))),"")
留言
張貼留言