A15:C21{=IFERROR(OFFSET($A$1,(COLUMN(A1)=4)*ROW(A2)+LOOKUP(SMALL(IF(1-ISERR(-$B$3:$B$10),ROW($3:$10)),ROW(A1)),IF($A$1:$A$7=$A$14,ROW($1:$7)))-1,(COLUMN(A1)*2-1)*(COLUMN(A1)<4)),"")
D15:D21{=INDEX(A:A,SMALL(IF(1-ISERR(-$B$3:$B$10),ROW($3:$10),99),ROW(A1)))&""
E15:H21=IF($D15="","",SUM(OFFSET($B$1,MATCH($D15,$A:$A,)-1,COLUMN(A1)*3-3,,3)))
留言
張貼留言