E2{=IFERROR(INDEX(A:A,SMALL(IF(MATCH(A$2:A$9,A$2:A$9,)=ROW($1:$8),IF(SMALL((A$2:A$9=TRANSPOSE(A$2:A$9))*TRANSPOSE(B$2:B$9)+ROW($2:$9)*10^5,ROW($1:$8)*8)-SMALL(IF(A$2:A$9=TRANSPOSE(A$2:A$9),TRANSPOSE(B$2:B$9),99999)+ROW($2:$9)*10^5,ROW($1:$8)*8-7)+1>=COLUMN(A:I),ROW($2:$9))),ROW(A1))),"")
F2{=IF(E2="","",MIN(IF(A$2:A$9=E2,B$2:B$9))+COUNTIF(E$2:E2,E2)-1)
G2{=IF(E2="","",LOOKUP(1,0/(F2>=IF(A$2:A$9=E2,B$2:B$9)),C$2:C$9))
留言
張貼留言