E4:E11{=IFERROR(SUBSTITUTE(T(OFFSET(B$1,SMALL(MATCH(B$4:B$10,B:B,)-1,ROW(A1)),)),E3,),"")
F4:G11{=IFERROR(INDEX(LOOKUP(ROW(3:9),ROW(3:9)/(OFFSET($A$4:$A$10,,($G$3=F$3)*2)<>""),OFFSET($A$4:$A$10,,($G$3=F$3)*2)),SMALL(IF($B$4:$B$10=LOOKUP(1,0/($E$4:$E4<>""),$E$4:$E4),ROW($1:$7)),ROW(A1)-LOOKUP(1,0/(LOOKUP(1,0/($E$4:$E4<>""),$E$4:$E4)=$E$4:$E4),ROW($1:1))+1)),"")
留言
張貼留言