E3:F6{=INDEX(A:A,SMALL(IF(1-ISERR(-$A$3:$A$14),ROW($3:$14),99),ROW(A1)))&""
G3:H6=IF(F3="","",VLOOKUP("Y",IF({1,0},OFFSET($C$1,MATCH($F3,$B:$B,)-1,,9),OFFSET($A$1,MATCH($F3,$B:$B,)-1,A$2=$B$2,9)),2,))
E9:H12{=IFERROR(LOOKUP(1,0/(SMALL(IF($C$3:$C$14="Y",ROW($3:$14)),ROW(A1))>=IF(COLUMN(A1)<3,IF(1-ISERR(-$A$3:$A$14),ROW($3:$14)),ROW($3:$14))),OFFSET($A$3:$A$14,,MAX(MOD(COLUMN(B1),2)))),"")
留言
張貼留言