F4:F11{=IFERROR(INDEX(A:A,RIGHT(SMALL(MATCH(A$4:A$16&"",A$4:A$16&"",)/1%+ROW($4:$16),ROW(A1)*2-1),2))&"","")
G4:I11{=OFFSET($A$1,RIGHT(SMALL(IF($A$4:$A$16=$F4,ROW($4:$16),99),COUNTIF($F$4:$F4,$F4)*2-1+(COLUMN(A1)=2)),2)-1,COLUMN(A1)-(COLUMN(A1)>1))&""
留言
張貼留言