P2:S12{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(COUNTIF($B:$B,IF({1,0},$B$2:$B$7,$G$2:$G$7))+COUNTIF($G:$G,IF({1,0},$B$2:$B$7,$G$2:$G$7))>1,IF({1,0},MATCH($B$2:$B$7,$B:$B,),IFERROR(MATCH($G$2:$G$7,$B:$B,),99))*10^8+ROW($2:$7)/1%+{0,5}*10001),ROW(A1)),4)+COLUMN(A1),"!R0C00"),),"")
留言
張貼留言