N3:R7{=INDEX($C:$C,MIN(IF(($A$2:$A$15=$M3)*($D$2:$D$15=N$2)*(MATCH($A$2:$A$15&$D$2:$D$15,$A$2:$A$15&$D$2:$D$15,)=ROW($1:$14)),ROW($2:$15),99)))&""
N13:N15{=IFERROR("ABC00"&SMALL(IF(COUNTIF(C:C,"ABC00"&ROW(INDIRECT(MIN(RIGHT(C$2:C$15,4)*1)&":"&MAX(RIGHT(C$2:C$15,4)*1))))=0,ROW(INDIRECT(MIN(RIGHT(C$2:C$15,4)*1)&":"&MAX(RIGHT(C$2:C$15,4)*1)))),ROW(A1)),"")
留言
張貼留言