I3:L6{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE($B3&"/"&$C3,"/",REPT(" ",29)),ROW($1:$9)*29-28,29)),SMALL(IF(MATCH(TRIM(MID(SUBSTITUTE($B3&"/"&$C3,"/",REPT(" ",29)),ROW($1:$9)*29-28,29)),TRIM(MID(SUBSTITUTE($B3&"/"&$C3,"/",REPT(" ",29)),ROW($1:$9)*29-28,29)),)=ROW($1:$9),ROW($1:$9)),COLUMN(A1))),"")
E3{=INDEX($A:$A,SMALL(IF(MMULT(N(I$3:L$6<>""),{1;1;1;1})>=COLUMN(A:I),ROW($3:$6),99),ROW(A1)))&""
G3{=IF(F3="","",INDEX(VLOOKUP(F3,A:L,{9,10,11,12},),SMALL(IF(VLOOKUP(F3,A:L,{9,10,11,12},)<>"",{1,2,3,4}),COUNTIF(F$3:F3,F3))))
留言
張貼留言