(2007版) F2 右拉 下拉{=IFERROR(IF(COLUMN(A1)=1,"","/")&INDEX($B:$B,SMALL(IF((MATCH($A$2:$A$23&$B$2:$B$23,$A$2:$A$23&$B$2:$B$23,)=ROW($1:$22))*($A$2:$A$23=$D2),ROW($2:$23)),COLUMN(A1)))&F2,"")
C2=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,IFERROR(LOOKUP(1,0/(A$1:A1=A2)/(C$1:C1<>""),C$1:C1)&"/"&B2,B2),"")
E7=LOOKUP(1,0/(A$2:A$23=D7)/(C$2:C$23<>""),C$2:C$23)
留言
張貼留言