彙整字首數字 放同列 (10794)


B12:F16{=IFERROR(INDIRECT(TEXT(SMALL(MMULT(N((0&LEFT($B$3:B$7))-COLUMN(A1)=0),TRANSPOSE(COLUMN($B:B)))+ROW($3:$7)/1%,ROW(A1)),"!R0C00"),),"")


留言