F3:F9{=INDEX(B:B,SMALL(IF(MATCH(COUNTIF(OFFSET(D$3,,,ROW($1:$10)),"<>")&$B$3:$B$12,COUNTIF(OFFSET(D$3,,,ROW($1:$10)),"<>")&$B$3:$B$12,)=ROW($1:$10),ROW($3:$12),99),ROW(A1)))&""
G3:G9{=IF(F3="","",SUM((COUNTIF(OFFSET(D$3,,,ROW($1:$10)),"<>")&$B$3:$B$12=INDEX(COUNTIF(OFFSET(D$3,,,ROW($1:$10)),"<>")&$B$3:$B$12,SMALL(IF(MATCH(COUNTIF(OFFSET(D$3,,,ROW($1:$10)),"<>")&$B$3:$B$12,COUNTIF(OFFSET(D$3,,,ROW($1:$10)),"<>")&$B$3:$B$12,)=ROW($1:$10),ROW($1:$10)),ROW(A1))))*C$3:C$12))
留言
張貼留言