尾數相同 彙整同行 (14058)

D3{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF((0&RIGHT($A$3:$B$16))-ROW(A1)=0,ROW($3:$16)/1%+{1,2}*10001),COLUMN(A1)),4),"!R0C00"),),"")



留言