(順序 1) E2:F10{=INDEX(A:A,SMALL(IF($B$2:$B$12<>"",ROW($2:$12),99),ROW(A1)))&""
(順序 2) H2:H10=IF(E2="","",LOOKUP(1,0/(A$3:A$12-E2=0)/(B$3:B$12=F2),LOOKUP(ROW($1:$10),ROW($1:$10)/FIND("Group",A$2:A$11),A$2:A$11)))
(順序 3) G2:G10=IF(E2="","",LOOKUP(1,0/(LOOKUP(ROW($1:$11),ROW($1:$11)/FIND("Group",A$2:A$12),A$2:A$12)=H2)/(C$2:C$12<>""),C$2:C$12))
留言
張貼留言