G2:H8{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(MAX($B:$E)=$B$2:$E$10,IF(A$1=$A$1,ROW($2:$10)/1%,ROW($2:$10)/1%%+100)+{2,3,4,5}^(A$1=$B$1)),ROW(A1)),4),"!R0C00"),),"")
I2:I8{=IF(G2="","",ADDRESS(SMALL(IF(MAX($B:$E)=$B$2:$E$10,ROW($2:$10)/1%+{2,3,4,5}),ROW(A1))%,RIGHT(SMALL(IF(MAX($B:$E)=$B$2:$E$10,ROW($2:$10)/1%+{2,3,4,5}),ROW(A1))),4))
留言
張貼留言